lalitkolhe (AT) lycos (DOT) co.uk (Lalit Kolhe) wrote in message
A few options for you:
1: Use Microsoft Data Link for your connections. Then set up a data
link connection file for each environment.

2: Using the DTSPackage object you could write an application that
opens DTS Package and presents the connections for modification before
execution.

3: Use global variables and dynamic properties tasks to set the
connection information within the package. Then use the DTSRun /A
switch to pass in the values for the global variables. Depending on
the contract I have passed in values for the servers (i.e. /A
gvSrceSrvr:8=MyServer) or flags for the environment (i.e. /A
gvEnvironment:8=Stage).

The third method is how I usually set up package for migration. I
prefer this because the package isn't dependent on additional files or
applications. And once a package is completed there isn't a need to
reopen the package to adjust and internal coding. The same package
that runs in development runs in production.

HTH
Jason Strate
J.strate (AT) comcast (DOT) net