Precedence Constraint Editor

 

Applies To: SQL Server 2016

Use the Precedence Constraint Editor dialog box to configure precedence constraints.

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.

System_CAPS_ICON_note.jpg 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.

System_CAPS_ICON_note.jpg 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.

System_CAPS_ICON_note.jpg Note


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

Precedence Constraints
Integration Services Tasks
Integration Services Containers
Integration Services (SSIS) Expressions

Community Additions

ADD
Show: