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.

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

  1. Open SQL Server Data Tools (SSDT).

  2. On the Tools menu, click Options.

  3. In the Options dialog box, expand Business Intelligence Designers, and then expand Integration Services Designers.

  4. Click Control Flow Auto Connect and select Connect a new shape to the selected shape by default.

  5. In the drop-down list, choose either Use a Failure constraint for the new shape or Use a Completion constraint for the new shape.

  6. Click OK.

To create a default 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, click the task or container and drag its connector to the executable to which you want the precedence constraint to apply.

  5. To save the updated package, click Save Selected Items on the File menu.

Community Additions