SSIS Container Types and Properties

SSIS Containers are part of SSIS architecture. They are designed to group related tasks together. In addition SSIS Containers allow defining variables and handlers within container itself. SSIS Containers can be of four different types.

  • SSIS Task Host Container is designed to a simple interface for any tasks. In other word, any SSIS task belongs to this container. Note: it is an interface and as such is not visible within BIDS.
  • SSIS Sequence Container is designed to group SSIS tasks into groups. You can close and open this container as needed.
  • SSIS For Loop Container is designed to loop through tasks until given condition has been met.
  • SSIS Foreach Loop Container is designed to iterate trough a data set and execute task for each record in the data set.

SSIS Containers have common properties which are helpful in developing SSIS Packages. They are all listed below:

Property

Description

DelayValidation

It indicates whether validation is delayed and it is Boolean type.

Disable

It indicates if container runs. It is also Boolean type.

DisableEventHandlers

It indicates if event handler runs. Boolean type of property.

FailPackageOnFailure

It specifies if package fails.

IsolationLevel

It specifies isolation level of a container: Unspecified, ReadUncommitted, ReadCommitted, RepeatableRead, Snapshot, Serializable and Chaos

MaximumErrorCount

It specifies number of errors before stoppage of a container

TransactionOption

It specifies whether transaction is needed: NotSupported, Supported, Required

Featured pages

Architecture

Learn SSIS architecture, key concepts and major SSIS components. Our online tutorials teach you pl…

Development

Learn how to develop SSIS based solutions and application. SSIS development tutorial explains SSIS…

Administration

Find out what is required to install and configure SSIS as well as what administrative task requir…