Unused Connection Managers

Hi,

I am unsure if i am managing my connections in the correct way... but as it stands we have them in a .dtsConfig file that each package references in order to get the relevant details..

This is working fine, except that in total our ETL project uses 6 different connections, and none of the packages utilise all 6.

This leads to an error message upon opening up EVERY package stating that there are connection strings in the .dtsConfig that are unused, yeah, thats the idea!

The way i have gotten around this, is to just include all 6 connection managers in every package, but my question is, is there a better way to achieve this same result

are we going about this in a bit of a cackhanded way

any incite would be useful..

Best Regards

Chris

I don't understand how this would work...

would i not need to provide a connection to get the connection

ok, thanks for the help all

i think for now ill stick with all the connections in each package, and then when i finally deploy it go with the configuration table..

thank you!