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

Figure 16-6 . Foreach Loop Editor General page that enumerates through each row in the packageListObject vari-
able
Then you need to tell Integration Services what to do with the value it retrieves
when enumerating through the object list. On the Variable Mappings page, set the vari-
able to @[User::packageName] and the Index to 0. This will put each value into
the variable.
Finally, you're at a point where you can add the part that executes the package.
Similar to the creation of the master-child package, you want to use an Execute Pack-
age task. Begin by setting the DelayValidation property to True , which allows
you to decide what package to run at runtime.
Rather than walk through the same steps as you did in the master-child package, go
directly to the Expressions page in the Execute Package Task Editor. This is where you