SSIS - Container

Ssis2

About

In SSIS control flow, containers:

  • group related tasks together
  • or define iterative processes.

As you can nest containers within other containers, it permits to create a hierarchy of task.

Containers can be start or endpoints for precedence constraints.

Ssis Container

Type

SSIS packages can contain the following kinds of container:

Task

Each control flow task has its own implicit container.

Sequence

Sequence containers group tasks and other containers.

It enables to:

  • set properties at the container level that apply to all elements within the container.
  • Disable a logical subset of the package for debugging purposes.
  • Create a scope for variables.
  • Manage transactions at a granular level.

Ssis Sequence Container

For Loop

For Loop containers performs a loop until a condition is met.

Ssis For Loop Container

The defined variable can be used with the following syntax:

@[User::counter]

Foreach Loop

Foreach Loop containers performs a loop with an collection.

  • File - Files in a folder.
  • Item – A property collection for an SSIS object.
  • ADO. A Recordset.
  • ADO.NET Schema Rowset. Tables in a dataset or rows in a table.
  • Variable – Array.
  • Nodelist - Elements and attributes in an XML document.
  • SMO – A collection of SQL Server Management Objects.

Ssis For Each Loop Container





Discover More
Ssis Control Flow Constraint Operation
SSIS - Control Flow (Workflow)

Control flow packages implements workflow logic. Each control flow task has its own implicit container. Data Flow Tasks Data Flow Encapsulates a data flow that transfers data from a source to a destination....
Ssis2
SSIS - Transaction

A transaction = A container Supported: Ik doe mee aan een transactie Required: Ik maak een transactie Isolation Level: Hoeveel last hebben we van elkaar Serializable (Ik ben alleen). Laat er...



Share this page:
Follow us:
Task Runner