Archive

Archive for the ‘Sequence Container’ Category

SSIS : Sequence Container

July 5, 2011 Leave a comment

Sequence containers is used to group the package into multiple separate control flows, each containing one or more tasks and containers that run within the overall package control flow. There are several advantages in using sequence container

  1. Provides facility to set property of multiple tasks by setting the property of sequence container.
  2. Provides the facility of disabling groups of tasks to focus debugging on one subset of the package control flow.
  1. Scope for variables that a group of related tasks and containers use can be controlled easily.
  2. Managing and visualization of group of tasks becomes easier using sequence container.
  3. We can also expand and collapse the container, hence making the package look neat.

Using Sequence Container

Create a new SSIS package ( refer video to create new SSIS package). Drag the sequence container from the toolbox on the left hand side into the package.

Read more…

 

Advertisements