Sunday, March 11, 2012

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.

No comments:

Post a Comment