In my SSIS Packages, I have my Package Configurations set up to first, use an XML Configuration File to set the configuration settings of my "CONFIG" connection. From there, my various other connections receive their values from a SQL Server Configuration Type via a Configuration Table that is located on each of my environments.
I am a bit hesitant to store a value for the Server in each connection even though it will get re-written on runtime from the configurations. I am hesitant because if for some odd reason, the XML Configuration File is missing, or the package is pointing to the wrong path, it will default what ever server has been hardcoded into the value of the connection.
Ideally, I would like to put a value like 'XXXXXXX' for the Server in all connections. In the case that an XML file could not be found, there would be no chance of the package inadvertantly running on the wrong server.
Is there an easy way to loop through all connections and set the values of the server to 'XXXXXX' prior to the Configuration component running? Perhaps a script task in an event handler?