Single configuration file for all the SSIS packages(including parent  and child packages)
As long as all the packages use the same Configured items (Connection Strings, Variables, Properties, etc) AND all the items listed in the Config file are used by each package, then you can simply edit each package to use the one XML Config file. But personally, being a database guy instead of an XML guy, I prefer to use SQL Server database for my configurations. Yes, I do have ONE XML config file in each Environment that indicates where the database is for that environment, but that's it. Read about it here.Todd C - MSCTS SQL Server 2005 - Please mark posts as answered where appropriate.
December 21st, 2010 1:00pm

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics