Database Reference
In-Depth Information
set up the dynamic portion of the package. Set the PackageName property to use the
expression @[User::packageName] . The final Expressions page should look like
Figure 16-7 .
Figure 16-7 . Execute Package Task Editor Expressions page
When the package runs, it will loop through each row in the PackageList table;
set the PackageName property of the Execute SQL task to the current row, and ex-
ecute only the packages that you need. Keep in mind that this will always run the child
packages serially unless you create multiple loops and specifically code your master
package to handle parallelism.
Next, we will describe how a child package can send information back to the parent
package in the child-to-parent variable pattern.
 
 
Search WWH ::




Custom Search