How to add the Execute SQL task to a DTS package (Enterprise Manager)

To add the Execute SQL task to a DTS package in DTS Designer

1. From the Connection toolbar, drag a connection onto the Data Transformation Services (DTS) design sheet and configure the connection.

   Note  The Execute SQL task requires one connection. If a connection is already configured in the package and you can access the data source through that connection, you can skip Step 1.

2. From the Task toolbar, drag an Execute SQL task to the design sheet.

See Also

Execute SQL Task