Workflow Properties (Precedence Tab)

DTS Designer

DTS Designer Help

Workflow Properties (Precedence Tab)

Use this tab to view and configure the relationships among tasks, transformations, and precedence constraints.

  • If you are configuring the properties of a precedence constraint, this tab displays the steps, from source to destination, that must be completed for the constraint to be exercised. You can also use the tab to add additional constraints to the preceding steps, delete constraints on those steps, or redefine existing constraints for those steps.

  • If you are configuring the workflow of a Transform Data task, this tab displays the source precedence constraints preceding the target transformation. You can also use the tab to add additional constraints to a workflow, delete constraints, or redefine existing constraints.

The order of constraints is not important. By default, each step is eligible for immediate execution.

Options

Source step

Select an available source step from the list.

Precedence

Specify task execution based on On completion, On success, or On failure status. You can also select <none> to terminate an existing relationship between a Source Step and Destination Step.

Destination step

Select an available destination step from the list.

New

Add a new constraint between two steps, which you then need to configure.

Delete

Delete an existing constraint between two steps.

See Also

DTS Package Workflow