I have and SSIS 2008 package that is configured to two different XML files. One called 'Global' that has database and server name information for connection strings (that all packages point to), and another that is more specific to operations in the specific package
(file paths, file names, etc).
A SQL Server Job will execute this package. Does it matter what order I have the config files in? My thought is that the database connections have to happen first, so the Global config file should be first, but I'm not sure.
Thank you for your help!
View Complete Post