Introduction

Till now we have seen how flow of execution can be defined in the Control Flow. There are trailing arrows after each task which defines the flow of execution. These arrows are called Precedence Constraints.

Precedence Constraint defines the execution flow not only by the state of the first task but also with the help of expressions. Combination of Expressions and Precedence Constraints make a Control Flow a powerful executable.

An important part of each application's Control Flow are the control structures, such as conditions and loop structures. SSIS, as an executable, has the ability to implement conditions with resort of Precedence Constraint. There are three types of containers in the Control Flow as shown in the following screenshot:

With Sequence Container, Control Flow Tasks get grouped together and will be considered as an executable object which has some properties. One of the most useful scenarios for sequence container is to use transactions which will be explored in...