sql server dts: When I create a new DTS Package I get a DTS Designer Error that states “There
was a problem retrieving the list of OLE DB providers.” When I click ok the
design window opens and I only have 2 connection icons where there should be
many more. I have the same issue when opening already existing DTS packages.
If I right click on a task in the package and go to properties, the window
opens just fine. As soon as I click ok I get an error saying “No provider is
selected. To continue, you must select a valid provider.” Other people I
work with have access to the same package and do not get these errors. I
have reinstalled SQL server 2000, and I’m on SP4. My MDAC is version 2.8
SP1. I’m on XP Pro SP2. Any help is appreciated.

Still having this issue. I have searched around and can't find any help.
If anyone has any help I'm willing to try anything to get working. Thanks