How To
How to configure workflow in the Execute SQL task (Enterprise Manager)
To configure workflow in the Execute SQL Task
- 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).
- 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.