Parent-Child Patterns - SQL Server Integration Services Design Patterns - page 391

Just calling a child package isn't very exciting. What is exciting is tying the child pack-
age into something that the master package is doing! You do this through parent pack-
age parameters. This option can only be used if you are using a child package from the
same project as the master package. Once you complete the setup for your package
parameters, you should see the screen shown in Figure 16-2 .
Figure 16-2 . Execute Package Task Editor Parameter Bindings page
To achieve the result shown in Figure 16-2 , you need to look at the Execute Pack-
age Task Editor and go to the Parameter Bindings page. Click the Add button to set up
a parameter. For the Child Package Parameter, you can either select a parameter that
has already been created or add your own parameter, in case you have not created the
child package's parameter yet. Keep in mind that this will not automatically create the
variable in the child package. That is up to you! Next, you will assign either a paramet-