Parent - Multiple Child Package Execution

SQL Server Integration Services

Karunakaran


I have a parent package "A", I also have 4 child packages "B","B1","B2",B3"

In BIDS, I created a file connection in the package "A" to connect to the child packages. So whenever I want to run B1 or B2, I change the path in the file connection to point to B1 or B2 and so on. Since the developement environment is File system this works perfectly fine.

But in the Test / Production environment all packages are stored in the Sql server. How can I paramaterize the child package connection so that I can use configuration / variables to select which child package to execute.

Thanks

Top

Re: Parent - Multiple Child Package Execution

Phil Brammer


Set up four execute package tasks that point to each child package. Then use a variable precedence constraint to determine which execute package task to run. You could make the variable an integer and then use something like: @ChildPackage == 1, @ChildPackage == 2, etc...




Top

Re: Parent - Multiple Child Package Execution

Karunakaran

One problem I see with this approach is that, If I develop another child package then I have to modify the master package to include this new child package and re-deploy. as the number of packages increases, it will be difficult to maintain. Basically I just want one execute package task which should be configurable ( say which package to execute or path of the package to execute)

Thanks



Top

Re: Parent - Multiple Child Package Execution

jwelch

Could you use two Execute Package tasks, one configured for executing on the file system, the other for the database Then use precedence constraints to control which one executes. So you'd pass in two variables - one being the connection to the package, the other setting a variable that controls which package executes.





Top