Which is a better configuration for server?

SQL Server Package Configuration

• How do I use a value from a Package Configuration in the Connection Manager? I am using an SQL Data Source, not an Environmental Variable. I have set up the Package Configuration on an SSIS package to point to a table that holds some Connection Strings. How do I set up a source or destination in the Connection Manager that uses this Connection String? I am using Visual Studio 08. I took over a project that will one day be moved from a development server to a production server. When that happens, we will want to update many of the connections to use a new location. A config table already exists and if I can get the connection strings passed to the packages, I can just update the location on the table instead of editing each package. What I've read about Package Configurations leads me to believe this is one way to do that, but I have not found any explanations on how. Many descriptions of how to set up and connect to the config table, but nothing on how to use the value you pull from the table to connect to a source. I am not looking for other methods to do that right now. I want to understand how this method is supposed to work. Thanks

• Answer:

  SSIS configurations are set on the assumption that you're using the same names for variables, connection managers, etc. All you should need to do is assign the config to the package itself at the package level, and it will farm out the values appropriately.