Padma-1078840 (12/21/2011)
Can someone please post an example on how exactly to implement changing configurations dynamically? I have about 350 packages that I need to run first on test and then on production. Is there a way to do it for all the packages at the same time? I have a sqlserver table set up with a list of all the production and test connection strings.
Please start a new thread instead of hijacking an old one.
Regarding your question, you can maybe automate it with .NET, but you better have some strong coding skills.
Another option is that you do not include the package configuration directly in the package, but that you provide an XML config file at runtime when you launch the package. All you have to do is create valid XML config files for each package using the values that are inside your table.
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP