Use an Expression in a Precedence Constraint


Applies To: SQL Server 2016

This procedure describes how to add an expression to a precedence constraint by using the Precedence Constraint Editor dialog box. Before you can add an expression to a precedence constraint, the package must include at least two executables, either tasks or containers, and they must be connected by a precedence constraint.

To add an expression to a precedence constraint

  1. In SQL Server Data Tools (SSDT), open the Integration Services project that contains the package you want.

  2. In Solution Explorer, double-click the package to open it.

  3. Click the Control Flow tab.

  4. On the design surface of the Control Flow tab, double-click the precedence constraint. The Precedence Constraint Editor opens.

  5. Select Expression, Expression and Constraint, or Expression or Constraint in the Evaluation operation list.

  6. Type an expression in the Expression text box or launch the Expression Builder to create an expression.

  7. To validate the expression syntax, click Test.

  8. To save the updated package, click Save Selected Items on the File menu.

Precedence Constraints
Connect Tasks and Containers by Using a Default Precedence Constraint
Set the Value of a Precedence Constraint by Using the Shortcut Menu
Set the Properties of a Precedence Constraint
Integration Services (SSIS) Expressions

Community Additions