Udostępnij za pośrednictwem


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.

    [!UWAGA]

    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.

    [!UWAGA]

    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.

    [!UWAGA]

    This type of precedence constraint appears as a dotted green, highlighted, or blue line.

Zobacz także

Zadania

Integration Services (SSIS) Expressions

Koncepcje

Precedence Constraints

Integration Services Tasks

Integration Services Containers