dts prob

Whenever i right click on an open dts and
choose "disconnect edit" i get this error:
Error Souce: Microsoft OLE DB Service Components
Error Description: Class not registered
Class not registered
Can anyone tell me why? How to i fix this?
Thanxs
> Whenever i right click on an open dts and
> choose "disconnect edit" i get this error:
> Error Souce: Microsoft OLE DB Service Components
> Error Description: Class not registered
> Class not registered
> Can anyone tell me why? How to i fix this?
> Thanxs
Reinstall MDAC and see how that goes. If that fails, get a regmon and
filemon capture to determine what dll is missing/unregistered.
Hope this helps,
Eric Crdenas
Senior support professional
This posting is provided "AS IS" with no warranties, and confers no rights.

dts prob

Whenever i right click on an open dts and
choose "disconnect edit" i get this error:
Error Souce: Microsoft OLE DB Service Components
Error Description: Class not registered
Class not registered
Can anyone tell me why? How to i fix this'
Thanxs> Whenever i right click on an open dts and
> choose "disconnect edit" i get this error:
> Error Souce: Microsoft OLE DB Service Components
> Error Description: Class not registered
> Class not registered
> Can anyone tell me why? How to i fix this'
> Thanxs
--
Reinstall MDAC and see how that goes. If that fails, get a regmon and
filemon capture to determine what dll is missing/unregistered.
Hope this helps,
Eric Crdenas
Senior support professional
This posting is provided "AS IS" with no warranties, and confers no rights.

DTS Package Error - Something simple?

I have a multi-step DTS package that I get the following error when I try to execute it:

Package Error
Error Source : microsoft ole db provider for sql server
Error Description : [DBNETLIB][ConnectionOpen (connect()).]SQL Server does not exist or access denied

Am I missing something obvious? I'm sure it is something simple but I can't seem to get it. Thank you in advance for you assistance.It means the package can't connect to a data source it wants to connect to. Open up the package in Design mode and look at the connection properties. Check that the server name, the authentication method, and the username and password are correct.