How to configure workflow in the Execute SQL task (Enterprise Manager)

How to Install SQL Server 2000

How To

How to configure workflow in the Execute SQL task (Enterprise Manager)

To configure workflow in the Execute SQL Task

  1. On the Data Transformation Services (DTS) design sheet, CTRL-click Drop Dest Table (the Execute SQL task you created), and then CTRL-click Cn1 (the first Northwind connection).

  2. Click the Workflow menu, and then click On success.

A green striped arrow appears pointing from Drop Dest Table to Cn1. This arrow is a conditional precedence constraint. It directs the workflow so that the first task must execute successfully in order for the next task (the Transform Data task) to run.