Share via


Use an Expression in a Precedence Constraint

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.

See Also

Tasks

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

Concepts

Precedence Constraints