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

packages need to run, you can create a master package that has a dynamic child pack-
age that will only execute the desired packages. This is a great idea if you have a series
of files coming in, but you're not sure which files come in at a certain time. Your end
goal is to create a package that looks like Figure 16-4 . Let's walk through an example
of creating the master package and a list of the dynamic packages that you want to ex-
ecute.
Figure 16-4 . Completed dynamic child package pattern package
To create the table that contains the package names, run the Create and Insert
statements found in Listing 16-2 . Either create a database named DesignPatterns ,