Is there a way to dynamically set the connection for the configuration table. For instance, if I wanted to change where all of the packages were looking for thier SSISConfiguration settings instead of looking on the (local) server.database that was setup in the package configuration. This way I can point all packages to one server and manage SSISConfiguration tables for DEV, QA, and PROD from there. If something happens and I have to move the SSISConfiguration tables to another server, is it possible to make the change in one place instead of having to open all of the packages and manually updating the connection to the SSISConfiguration table?
What would I need to do to accomplish this?