SSIS Package deployment


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..
banjara15Asked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

banjara15Author Commented:

Guys, please let me know your expert feedback so I could proceed in the right direction..

Thanks agian to all..
0
Steve HoggITCommented:
Use the separate config files with each Child, that is fine. However, if you could pass all of the configuration data into the Parent, then the Child packages could be configured to read a Parent value. But separate files is fine too, especially if you might run the Child packages stand alone.
I prefer to pass the child values from the Parent, and only use the Child packages as such. Do you have a more specific question that I could help with?
Good Luck
HoggZilla
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
banjara15Author Commented:

Thanks a lot for your help. I decided to use only one config file for the main package. For all the child packages I am passing the value through the variable...
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft SQL Server

From novice to tech pro — start learning today.