How to: Connect Tasks and Containers Using a Default Precedence Constraint
Precedence constraints connect two executables. An executable can be any task or a For Loop, Foreach Loop, or Sequence container. This procedure describes how to set the default behavior for precedence constraints, and how to connect executables using the default precedence constraints.
Creating Default Precedence Constraints
When you first use SSIS Designer, the default value of a precedence constraint is Success. Follow these steps to configure SSIS Designer to use a different default value for precedence constraints.
To set the default value for precedence constraints
Open Business Intelligence Development Studio.
On the Tools menu, click Options.
In the Options dialog box, expand Business Intelligence Designers, and then expand Integration Services Designers.
Click Control Flow Auto Connect and select Connect a new shape to the selected shape by default.
In the drop-down list, choose either Use a Failure constraint for the new shape or Use a Completion constraint for the new shape.
Click OK.
To create a default precedence constraint
In Business Intelligence Development Studio, open the Integration Services project that contains the package you want.
In Solution Explorer, double-click the package to open it.
Click the Control Flow tab.
On the design surface of the Control Flow tab, click the task or container and drag its connector to the executable to which you want the precedence constraint to apply.
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: 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
How to: Add an Expression to a Precedence Constraint
Concepts
Precedence Constraints
Control Flow How-to Topics (SSIS)