Database Reference
In-Depth Information
Figure 7-13.
The data destinations
Data flow destinations can have an error output containing errors that occur when writing data to the
destination data store. Errors can occur for a number of reasons, but one example is attempting to insert
duplicate data into a primary key column.
Using Sequence Containers
Another common element of an SSIS package is the
sequence container.
Its main purpose is to group control flow
tasks. These containers have additional helpful features within the sequence container. These features include
the following:
•
Expand and collapse arrows on the upper-right side of the sequence container allow you
to show or hide tasks within it.
•
Properties within a sequence container affect the same property setting on the tasks
inside the container.
•
Disabling a sequence container disables the tasks inside it.
•
Configuring a sequence container as part of an SSIS transaction allows you to commit or
roll back the tasks inside.
