MSBI # 24 – SSIS # 11 – Control Flow Tasks # 6 – Sequence Container Task

Continuing from my last post on SSIS Control flow task in which we talk lot about For Each Loop Container:

MSBI # 23 – SSIS # 10 – Control Flow Tasks # 5 – For Each Loop Container Task « (B)usiness (I)ntelligence Mentalist

Now lets learn each and every aspects of sequence container task

We are covering following points in this article 

  • Why Sequence Container Task is Use ?
  • How Sequence Container Task is look like ?
  • Features of Sequence Container Task
  • How to use Sequence Container Task ?
  • What is alternative For Each Sequence Container Task ?
  • Demonstration of using Sequence Container Task ?
  • Various Properties For each Sequence Container Task ?
  • Reference link For Sequence Container Task

Why Sequence Container Task is Use

  • When we want perform some task sequentially or parallel we are going to make use of most of sequence container
  • which means though the name of the task is sequence container make point it can perform following two task:(A) Sequential execution of task (B)Parallel execution of task
  • The Sequence container groups together several tasks.
  • Use it to define a transaction boundary around a set of tasks so they all fail or succeed together. Or, use it simply to reduce the clutter on the design surface by hiding the detailed steps within the sequence.
  • We can also group control flow objects, and collapse or expand those groups. There’s no task for grouping.

Benefits of using a Sequence container:

  • Disabling groups of tasks to focus package debugging on one subset of the package control flow.
  • Managing properties on multiple tasks in one location by setting properties on a Sequence container instead of on the individual tasks.
  • Providing scope for variables that a group of related tasks and containers use.

How Sequence Container Task is look like ?

Its third in toolbox as shown :

image

Drag that out into your development plane

image

Features of Sequence Container Task

  • If a package has many tasks then it is easier to group the tasks in Sequence Containers and you can collapse and expand Sequence Containers
  • Sequence Container provides the facility of disabling groups of tasks to focus debugging on one subset of the package control flow
  • It have ability of managing multiple tasks in one location by setting properties on a Sequence Container instead of setting properties on the individual tasks
  • Provides scope for variables that a group of related tasks and containers use.

How to use Sequence Container Task ?  and

Demonstration of using Sequence Container Task ?

1. To begin, right click on SSIS Packages folder in Solution Explorer and click New SSIS Package. Rename it with MyFirstSequenceContainer.dtsx as Following :

image

2.Drag that out into your development plane

image

3.Drag Execute SQL Task inside sequence Container

image

Here we may have two way configuration of task as show in respective diagram

(A)Parallel Execution of Task in Sequence Container : In this container all will execute parallel

image

(B)Sequential Execution of task in Sequence Container : In this container all will execute Sequence in 1>>2>>3 way

image

Now lets combine in single solution to have same solution for analysis

image

4.Set the Connection string and SQL command in each Execute SQL Task in following manner

image

5.Lets run and see the real magic in fraction but still I have tried to explained bit diagrammatically

image

What is alternative For Each Sequence Container Task ?

Frankly there is two option as have explained in previous two post

1.For Loop Container Task  : MSBI # 22 – SSIS # 9 – Control Flow Tasks # 4 – For Loop Container Task « (B)usiness (I)ntelligence Mentalist

2.For Each Loop Container Task : MSBI # 23 – SSIS # 10 – Control Flow Tasks # 5 – For Each Loop Container Task « (B)usiness (I)ntelligence Mentalist

But make sure I will suggest you to go with sequential container always if you multithreading i.e parallel execution of various task :

SSIS How to Process Data as Fastest,Parallel , Multithreaded or in Very Efficient Way !!!

Various Properties For each Sequence Container Task ?

Its has following properties as shown :

image

In this also if we wan special feature for execution in parallel please go through following link

Reference link For Sequence Container Task

IMP Thread to look

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

Blog at WordPress.com.

Up ↑

%d bloggers like this: