<div>
They were probably created with a different version and/or Service Pack to the one you have installed.
</div>


They were probably created with a different version and/or Service Pack to the one you have installed.

<div>
Any DTS package.. &nbsp; &nbsp;when I right-click on the package and select Design Package... &nbsp; i get this error message first before it opens the design ... &nbsp;<br />
<br />
DTS Designer Error &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; <br />
<br />
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &quot;There was a problem retrieving the list of OLE DB providers&quot;<br />
<br />
<br />
I am beyond frustrated..<br />

</div>


Any DTS package..    when I right-click on the package and select Design Package...   i get this error message first before it opens the design ...  

DTS Designer Error          

              "There was a problem retrieving the list of OLE DB providers"


I am beyond frustrated..


<div>
chhapia &nbsp;~ &nbsp;YES! &nbsp; &nbsp;That fixed it.. &nbsp; how did you know this? &nbsp; &nbsp;i'm happy at the same time frustrated.... &nbsp; how would i have ever figured that out?<br />
<br />

</div>


chhapia  ~  YES!    That fixed it..   how did you know this?    i'm happy at the same time frustrated....   how would i have ever figured that out?



<div>
by chance, do you know where in the registry to find this change? &nbsp; &nbsp;what does this change in the registry?
</div>


by chance, do you know where in the registry to find this change?    what does this change in the registry?

<div>
I have faced same problem and one of my friends had suggested me to re-register the sqloledb.dll file.<br />

</div>


I have faced same problem and one of my friends had suggested me to re-register the sqloledb.dll file.


<div>
<div class="content wysiwyg-content">
Anyone know how to troubleshoot this error? &nbsp; &nbsp;When opening up a previously saved DTS package... &nbsp;i first get an error:<br />
<br />
- - - - - - <br />
DTS Designer Error &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &quot;There was a problem retrieving the list of OLE DB providers&quot;<br />
- - - - - - <br />
<br />
I just installed a local copy of SQL Server 2000 Eval Edition on my Windows XP Prof &nbsp;and cannot get past this error, wondering what it means..
</div>
</div>


Anyone know how to troubleshoot this error?    When opening up a previously saved DTS package...  i first get an error:

- - - - - - 
DTS Designer Error           "There was a problem retrieving the list of OLE DB providers"
- - - - - - 

I just installed a local copy of SQL Server 2000 Eval Edition on my Windows XP Prof  and cannot get past this error, wondering what it means..

opening a DTS Package..  error

Microsoft SQL Server is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.SQL Server is available in multiple versions, typically identified by release year, and versions are subdivided into editions to distinguish between product functionality. Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning.