I am trying to set a process up for SSIS packages for my employer.
We are implementing XML configuration files as a part of our SSIS packages. We have a promotion process that does allow code changes when going from client test to production as most people probably do.
As we promote packages, at the minimum connection manager data will need to be changed.
What is the best way, editors, etc, to create and maintain a script to change the confguration files?