sql server dts: Hi,
SSIS packages are now created and tested against dev sql server.
Now I would like them all to point to the live sql server.
What is the best way to have the connection dynamic?
Obviously I prefer not to go through each package and change the connection
manager.

I have each connection manager use Dynamic Properties to have a package
variable as the connection string. The value of the package variable is
configured using indirect configurations from SQL Server. That way, all I
need is a different value for the environment variable on each server. This
also applies to all the package logging which is therefore automatically
configured for each server. BTW the reason I don't have the connection
manager's connectionstring use the configuration file is that once a package
loads, there will be an error if a connection configuration path can't be
found in a package, but just a warning if a variable path can't be found.
Please ask more if any of this is unclear - I learned plenty of painful
lessons setting it all up!
HTH,
Paul Ibison