SSIS Containers

[[articles:SQL Server Integration Services (SSIS)|SSIS]] includes the following containers:

  • [[articles:SSIS For Loop Container|For Loop Container]]
  • [[articles:SSIS Foreach Loop container|Foreach Loop container]]
  • [[articles:SSIS Sequence Container|Sequence Container]]

[[articles:SQL Server Integration Services (SSIS)|SSIS]] also implicitly includes the following containers:

  • [[articles:SSIS Eventhandler Container|Eventhandler Container]]
  • [[articles:SSIS TaskHost Container|TaskHost Container]]
  • [[articles:SSIS Package Container|Package Container]]

Implicit because they are not something that a [[articles:SSIS Package|package]] developer would ever actually see in the toolbox but they do exist and they are important to how [[articles:SQL Server Integration Services (SSIS)|SSIS]] works.

 

Each [[articles:SSIS package|package]] is a representation of a hierarchy of containers which is referred to informally as the [[articles:SSIS container hierarchy|container hierarchy]].