using SQL Server 2000, in a dts package when I create a connection object, if I type in the full address of the named instance including port I can connect without any problem. However, if I try to set the server as [local] I get an error message :
--------------------------
-
Package Error
--------------------------
-
Error Source : Microsoft OLE DB Provider for SQL Server
Error Description : [DBNETLIB][ConnectionOpen (Connect()).]SQL Server does not exist or access denied.
I want to be able to specify local so that we can deploy the package to different environments without the need for editing.
thanks in advance for your help
Paul
Start Free Trial
