Hello, I like to maintain the all the common DB connections in the database, so it is easy when i switch to different environment. I am following the instructions in Microsoft SSIS 2008 Problem, Design and Solution book. I dont quite understand what they are saying: I create a variable and then the second step is to create a oledb connection in the template. If I am creating a oledb connection manually, it defeats the purpose, right? More over, If I need to point to different server, I need to update each every and package. Am I missing something? What is the suggested approach for easy maintenance? I am quite to new SSIS. Thanks,

Use configuration settings: http://www.mssqltips.com/tip.asp?tip=1405Arthur My Blog

You're "missing" the fact that you need to define a connection manager for each connection in your package with "default" values. At runtime, the dynamic configuration you're retrieving from SQL (via the indirect XML config) will change the connection information. When the time comes to change the connections, or move the packages, you won't need to open and edit any packages at all. You'll just need to change the environment variable and/or SQL config table. Talk to me now on