Applying Multiple Precedence Constraints
A precedence constraint connects two executables: two tasks, two containers, or one of each. They are known as the precedence executable and the constrained executable. For more information, see Precedence Constraints.
A constrained executable can have multiple precedence constraints. If a task or a container has multiple constraints, the LogicalAnd property specifies whether a precedence constraint is evaluated singly or in concert with other constraints.
Assembling complex constraint scenarios by grouping constraints enables you to implement complex control flow in packages. For example, in the following illustration, task D is linked to task A by a Success constraint, task D is linked to task B by a Failure constraint, and task D is linked to task C by a Success constraint.
The precedence constraints between task A and task D, between task B and task D, and between task C and task D participate in a logical and relationship. For task D to run, task A and task C must run successfully, and task B must fail.
.gif "Multiple precedence constraints")
You can set the LogicalAnd property using the Precedence Constraint Editor in SSIS Designer, or in the Properties window that Business Intelligence Development Studio provides.
Procedures
To configure a precedence constraint
How to: Set Precedence Constraint Properties Using the Precedence Constraint Editor
How to: Set Precedence Constraint Properties in the Properties Window
See Also
Tasks
Adding Expressions to Precedence Constraints
Setting Precedence Constraints on Tasks and Containers