I am migrating an SSIS solution from one data center to another. The existing packages are of 2008 version. I have upgraded them to 2017. Now I have to test them in Test server before moving them to production. The connections are all dynamic and they are fetching the server name and paths from SSISConfigurations table. I have changed the values in the table in Test server and updated the variables in the Master package.
I was told that is all I need to change and the same variables which are used for the child packages will be automatically updated. But after executing the master package I found that the change is reflected only in master package. The connections(variables) of other packages are still unchanged.
How can I can configure the connections of all the packages at one go? There are more than 60 packages so doing them manually is out of question. Please keep in mind I am still pretty new to MSBI.
Thank you
well i didn't need to to do all the packages at one go as it seemed. All I had to do was update the SSISConfigurations table and the the configuration was updated. Thanks for your suggestion