[2 days left] What’s wrong with your cloud strategy? Learn why multicloud solutions matter with Nimble Storage.Register Now

x
?
Solved

opening a DTS Package..  error

Posted on 2006-06-20
6
Medium Priority
?
543 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 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
Windows Server 2016: All you need to know

Learn about Hyper-V features that increase functionality and usability of Microsoft Windows Server 2016. Also, throughout this eBook, you’ll find some basic PowerShell examples that will help you leverage the scripts in your environments!

 

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

Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

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

I have a large data set and a SSIS package. How can I load this file in multi threading?
Ready to get certified? Check out some courses that help you prepare for third-party exams.
Via a live example, show how to extract insert data into a SQL Server database table using the Import/Export option and Bulk Insert.
This videos aims to give the viewer a basic demonstration of how a user can query current session information by using the SYS_CONTEXT function

649 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