I'm working with a client to update the client's ETL process. The current process uses SSIS 2008 R2. There is a custom execution mechanism which executes each package, and automatically applies a package configuration file.
There are about 100 SSIS packages needed to run the ETL. They are set up so that they all use the same names for connection managers, so that one configuration file can be applied to many packages.
The problem I am having, is that I need to add a new connection manager to just one package. The way it looks like things work right now, I either need to make a special configuration just for this package, or I need to add the same connection manager to all the other packages, even though it is not used.
Question: Is it possible to have settings in a package configuration file that will be ignored the package has no property or object by that name? It seems like this throws an error, but I am not certain.
Final Note: I recognize that there are much better ways to do what my client is doing. However, they are on a strict timeline, and we strongly desire to modify the existing system as little as possible. Upgrading is not an option, nor is re-architecting the ETL process.
