Generating an SSIS package with Execute SQL Tasks
Now let's create an SSIS package with some more meat on it. The original SSIS package that I want to generate automatically, DailyETLMain.dtsx, contains multiple tasks within each Sequence Container, such as an Expression Task and Execute SQL Tasks, as shown in the following screenshot:
Figure 10.10 – A screenshot showing DailyETLMain.dtsx
We will begin with the Biml code that was started in the previous recipe and programmatically add precedence constraints, connections, variables, and tasks within each Sequence Container. What we want to accomplish in this recipe is generating an SSIS package with Sequence Containers that will run one after another on success. Each sequence container will contain four tasks: one Expression Task and three Execute SQL Tasks. The resulting package will be one more step toward using Biml to automatically generate a sample DailyETLMain.dtsx SSIS package from the Wide...
