O'Reilly logo

SQL Server DTS by Steve Hughes,, Steve Miller,, Marcelino Santos,, Brian Sullivan, Jim Samuelson,

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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

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

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required