Connect Tasks and Containers by 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 SQL Server Data Tools (SSDT).
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 SQL Server Data Tools (SSDT), 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.
Zobacz także
Zadania
Set the Value of a Precedence Constraint by Using the Shortcut Menu
Set the Properties of a Precedence Constraint
Use an Expression in a Precedence Constraint