• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 550
  • Last Modified:

opening a DTS Package.. error

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
lblinc
Asked:
lblinc
  • 3
  • 2
1 Solution
 
Anthony PerkinsCommented:
They were probably created with a different version and/or Service Pack to the one you have installed.
0
 
lblincAuthor Commented:
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
 
chhapia_chintakCommented:
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
Get your problem seen by more experts

Be seen. Boost your question’s priority for more expert views and faster solutions

 
lblincAuthor Commented:
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
 
lblincAuthor Commented:
by chance, do you know where in the registry to find this change?    what does this change in the registry?
0
 
chhapia_chintakCommented:
I have faced same problem and one of my friends had suggested me to re-register the sqloledb.dll file.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say thank you for being a part of the community.

  • 3
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now