Why Do we need Sequence Container in SSIS

In this Tutorial, we will talk about how, where, and why you need to use Sequence Containers in SSIS

CREATE MULTIPLE DATA FLOW TASKS WITH THE SAME NAME

In The Below example, we Have created two Data Flow Tasks and tried to give them the same name, as you can see that SSIS Will not allow us to give them the same name.

The Above Problem occurs as the whole of the Control Flow and can be thought of as a Single Sequence Container.

To Solve this issue we can put the two Data Flow Tasks with the same name in Two Different Sequence Containers.

GROUPING TASKS SO THAT YOU CAN DISABLE A PART OF THE PACKAGE THAT’S NO LONGER NEEDED

Grouping tasks so that you can disable a part of the package that’s no longer needed

We can use the sequence containers to Enable/Disable Certain Parts of the Control flow.

NARROWING THE SCOPE OF THE VARIABLE TO A CONTAINER

In Sequence Containers, we can narrow down the scope of a Variable So that the Scope Variable can be Mapped to a Particular Sequence Container.

CREATING EVENT HANDLERS ON A SINGLE CONTAINER, WHEREIN YOU COULD SEND AN EMAIL IF ANYTHING INSIDE ONE CONTAINER FAILS AND PERHAPS A PAGE IF ANYTHING ELSE FAILS

We can Create a Sequence Container and Create a Sequence Container Level Event Handler. So that if there are some issues in the Sequence Container we can perform Specific Actions like sending an Email that Sequence Container 1 has Failed.

MANAGING THE PROPERTIES OF MULTIPLE TASKS IN ONE STEP BY SETTING THE PROPERTIES OF THE CONTAINER

We Can Set the Property of Individual Sequence Containers as Shown Below.

USING ONE METHOD TO ENSURE THAT MULTIPLE TASKS HAVE TO EXECUTE SUCCESSFULLY BEFORE THE NEXT TASK EXECUTES

using one method to ensure that multiple tasks have to execute successfully before the next task executes