All of my SSIS packages use Package configurations. I have built a wrapper package that runs my Daily Data Warehouse process.
In that wrapper package there are many Execute package tasks that execute the various SSIS packages within my Data Warehouse process (all which
use Package Configurations). My question is when I create a scheduled job in the SQL Server Agent for the wrapper package do I need to define only the Package Configuration for the wrapper package. Will each individual Execute Package tasks use its defined
package configuration even though it is not part of the job I have created in the SQL Server Agent?
View Complete Post