Database Reference
In-Depth Information
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
Search WWH ::
Custom Search