I have developed some SSIS packages in SQL Server 2005. Mainly it consists of 1 master (parent) package and 4 child packages. The master package is using "Execute SSIS Package" tasks to execute the child packages. As I am new in SSIS development my question is regarding the "Configuration" files. Should each child package have its own config file, or there should be only one config file for parent package.
I'll appreciate if you could explain a typical setup of a parent packages with multiple child packages. Also what steps should I follow for deployment. I want to use SQL Server agent for deployment. I have created XML config files for each child package.
Appreciate your help..