SQL Server Integration Services (SSIS) - Sequential Container Task in SSIS

Introduction

In this article we are going to see how to use a Sequential Task container. This container is used in areas where the process needs to follow certain tasks sequentially. Sequential Task groups the tasks into multiple control flows and executes the process sequentially. We can use this task widely based on our requirements; such as disabling a sequence when it should not process or using it when managing multiple tasks in one location. We can easily disable a set of tasks of sequential tasks by disabling a sequential task alone which can esily be done. If there are many tasks in our package we can group them based on their sequence and used to collapse and expand them and also to enable and disable them easily.

Steps

Follow steps 1 to 3 on my first article to open the BIDS project and select the integration services project to work on. Once the project is created, we will see how to use Sequential Container Task in SSIS packaging.

Once we are into the BIDS, now we will start by dragging and dropping a sequential container task in the designer view as shown in the screen below.

Now add a variable as shown in the screen below.

Now we need to create a script task by dragging and dropping it and double-clicking on it; that will open the screen shown below. Here we need to add the variable to the Readonly variable as shown below.

Now click on the Design Script button, which will open the window shown below where we need to write a script as shown below in the main method.

Now add a sequential container flow for each day of week as shown in the below screen and connect to the script task.

Now click on the green arrow of each task and do the same as shown in the below screen shot for different days.

After you have given the expressions for each task your screen will look as shown below.

Now right click and execute the package. Or Press F5 directly.

Conclusion

So in this article we have seen how to use a Sequential container task and how to configure and use it appropriately.