Jaa


How to: Add an Expression to 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 Business Intelligence Development Studio, 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.

  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

Setting Precedence Constraints on Tasks and Containers
How to: Connect Tasks and Containers Using a Default Precedence Constraint
How to: Set the Precedence Constraint Value Using the Shortcut Menu
How to: Set Precedence Constraint Properties Using the Precedence Constraint Editor
How to: Set Precedence Constraint Properties in the Properties Window

Concepts

Precedence Constraints
Control Flow How-to Topics (SSIS)

Other Resources

Integration Services Expression Reference

Help and Information

Getting SQL Server 2005 Assistance