sql server dts: Connections in DTS Package -- sql server dts

Connections in DTS Package

Joan Brown
4/28/2004 8:33:18 PM

sql server dts:

We are using three servers (development, test/qa, and
production). How can I code a connection in a package to
reference the local server?

We are using 'save as' to migrate from one server to
another but we still have to modify the package on the
destination server to have the correct server
connections. There must be a better way surely.

Re: Connections in DTS Package

Allan Mitchell
4/29/2004 6:59:47 AM

You can do this a number of ways

1. I never do it but what about using . as the server name (not what I
would do)
2. You create an alias in cliconfg to point to the local server. You
always call this the same name so ThisIsLocal. You can then use that in
your connections
3. Have the package set the value after reading froma n external location
the name of the server
4. Set the name of the server from a piece of VBScript inside the package.

--
--

Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
www.SQLDTS.com - The site for all your DTS needs.
I support PASS - the definitive, global community
for SQL Server professionals - http://www.sqlpass.org

[quoted text, click to view]