Precedence Constraint Editor
Use the Precedence Constraint Editor dialog box to configure precedence constraints.
Options
- Evaluation operation
Specify the evaluation operation that the precedence constraint uses. The operations are: Constraint, Expression, Expression and Constraint, and Expression or Constraint.
Value
Specify the constraint value: Success, Failure, or Completion.Note
The precedence constraint line is green for Success, red for Failure, and blue for Completion.
- Expression
If using the operations Expression, Expression and Constraint, or Expression or Constraint, type an expression. The expression must evaluate to a Boolean.
- Test
Validate the expression.
Logical AND
Select to specify that multiple precedence constraints on the same executable must be evaluated together. All constraints must evaluate to True.Note
This type of precedence constraint appears as a solid green, red, or blue line.
Logical OR
Select to specify that multiple precedence constraints on the same executable must be evaluated together. At least one constraint must evaluate to True.Note
This type of precedence constraint appears as a dotted green, red, or blue line.
See Also
Reference
Other Resources
Precedence Constraints
Integration Services Tasks
Integration Services Containers
Setting Precedence Constraints on Tasks and Containers
Syntax (SSIS)
Integration Services Expression Reference