Home > SSIS Best Practices > SSIS – Sequence Container

SSIS – Sequence Container

Another favorite in SSIS is the Sequence container in SSIS packages. It can group different components at ‘Control Flow’ level.

There are many 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.

For more information on Sequence containers, please see http://msdn2.microsoft.com/en-us/library/ms139855.aspx.

Categories: SSIS Best Practices
  1. No comments yet.
  1. No trackbacks yet.

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

%d bloggers like this: