Precedence Constraint Editor
Applies To: SQL Server 2016
Use the Precedence Constraint Editor dialog box to configure precedence constraints.
Specify the evaluation operation that the precedence constraint uses. The operations are: Constraint, Expression, Expression and Constraint, and Expression or Constraint.
Specify the constraint value: Success, Failure, or Completion.
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.
Validate the expression.
Select to specify that multiple precedence constraints on the same executable must be evaluated together. All constraints must evaluate to True.
Select to specify that multiple precedence constraints on the same executable must be evaluated together. At least one constraint must evaluate to True.