Chapter 6. DTS Workflows

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


On Success


On Failure


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 ...

Get SQL Server DTS now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.