Simon Storey (6/3/2009)
Any chance you can post sample of your technique to swap connections based on environment dynamically.
The article describes a way of managing multiple package configurations easily, it assumes the reader already has some knowledge of configuration usage. The example package in the article only modifies some package variable values, but it works the same way for connection manager properties, task properties, or anything else you want to configure.
1. Create a package with a connection manager.
2. Use package configuration to put the connection manager properties in a SQL table.
3. Use the techniques in the article to supply multiple values.
The SSISConfiguration.sql file linked under "Resources" in the article has all the code.