SQL Server DTS

Chapter 6. DTS Workflows

Precedence constraints and steps are used to define the workflow in the DTS packages. Microsoft SQL Server provides three precedence constraints for use in designing the package workflow. Table 6.1 gives the types of constraints and the colors used to designate them in the DTS Designer window.

Table 6.1. DTS Precedence Constraints

Precedence Constraint	Arrow Color
On Completion	Blue
On Success	Green
On Failure	Red

How to Use DTS Workflows

To use the workflows within a DTS package, you should select two tasks in the DTS Designer and then select the precedence constraint you need from the Workflow menu or from the shortcut menu ...