[Webinar] Streamline your web hosting managementRegister Today

x
?
Solved

opening a DTS Package..  error

Posted on 2006-06-20
6
Medium Priority
?
550 Views
Last Modified: 2013-11-30
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..
0
Comment
Question by:lblinc
  • 3
  • 2
6 Comments
 
LVL 75

Expert Comment

by:Anthony Perkins
ID: 16947628
They were probably created with a different version and/or Service Pack to the one you have installed.
0
 

Author Comment

by:lblinc
ID: 16948180
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..
0
 
LVL 3

Accepted Solution

by:
chhapia_chintak earned 1000 total points
ID: 16948673
To resolve this problem, reregister the "sqloledb.dll" DLL as follows:

1. At a command prompt, change to the C:\Program Files\Common Files\System\Ole DB folder.
2. At a command prompt, type the following command:
regsvr32 sqloledb.dll
3. You should receive confirmation that the DLL is registered successfully.

Hope this helps
0
[Webinar] Improve your customer journey

A positive customer journey is important in attracting and retaining business. To improve this experience, you can use Google Maps APIs to increase checkout conversions, boost user engagement, and optimize order fulfillment. Learn how in this webinar presented by Dito.

 

Author Comment

by:lblinc
ID: 16954782
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?

0
 

Author Comment

by:lblinc
ID: 16954840
by chance, do you know where in the registry to find this change?    what does this change in the registry?
0
 
LVL 3

Expert Comment

by:chhapia_chintak
ID: 16957105
I have faced same problem and one of my friends had suggested me to re-register the sqloledb.dll file.
0

Featured Post

Upgrade your Question Security!

Your question, your audience. Choose who sees your identity—and your question—with question security.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Ready to get certified? Check out some courses that help you prepare for third-party exams.
MSSQL DB-maintenance also needs implementation of multiple activities. However, unprecedented errors can hamper the database management. In that case, deploying Stellar SQL Database Toolkit ensures fast and accurate database and backup repair as wel…
This video shows, step by step, how to configure Oracle Heterogeneous Services via the Generic Gateway Agent in order to make a connection from an Oracle session and access a remote SQL Server database table.
Via a live example combined with referencing Books Online, show some of the information that can be extracted from the Catalog Views in SQL Server.
Suggested Courses

613 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question