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, highlighted for Failure, and blue for Completion.

  • Expression
    If using the operations Expression, Expression and Constraint, or Expression or Constraint, type an expression or launch the Expression Builder to create the 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, highlighted 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, highlighted, or blue line.

See Also

Tasks

Integration Services (SSIS) Expressions

Concepts

Precedence Constraints

Integration Services Tasks

Integration Services Containers