Sequence Container: putting all tasks in an executable object
Sequence Container is the first container which will be covered in this chapter. SSIS Control Flow Tasks play an executable role and each task is an executable. Every executable can have one or more precedence constraints, and one or more outputs.
The Sequence Container will group one or more executable together and create an executable object. Transactions and some settings can be applied on a Sequence Container. We will discuss this in the later recipes.
In this recipe, we will reveal a sample of the Sequence Container and we will demonstrate when and how a Sequence Container will be helpful.
How to do it...
Create a SSIS project and name it as
R01_Sequence Container.Add a Sequence Container from the Control Flow Toolbox under the Containers section into the Control Flow.
Add an Execute SQL Task inside the Sequence Container and connect it to AdventureWorks2012.
Type the following statement in the SqlStatement property (This statement...
