Jaa


How to: Set Precedence Constraint Properties Using the Precedence Constraint Editor

This procedure describes how to set properties on precedence constraints by using the Precedence Constraint Editor dialog box.

To configure 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. Double-click the precedence constraint. The Precedence Constraint Editor opens.

  5. In the Evaluation operation drop-down list, select an evaluation operation.

  6. In the Value drop-down list, select the execution result of the precedence executable.

  7. If the evaluation operation uses an expression, in the Expression box, type an expression, and click Test to evaluate the expression.

    Note

    Variable names are case-sensitive.

  8. If multiple tasks or containers are connected to the constrained executable, select Logical AND to specify that the execution results of all preceding executables must evaluate to true. Select Logical OR to specify that only one execution result must evaluate to true.

  9. Click OK to close the Precedence Constraint Editor.

  10. 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 in the Properties Window
How to: Add an Expression to a Precedence Constraint

Concepts

Precedence Constraints
Control Flow How-to Topics (SSIS)

Other Resources

Integration Services Expression Concepts

Help and Information

Getting SQL Server 2005 Assistance