How to add the Bulk Insert task to a DTS package (Enterprise Manager)

How to add the Bulk Insert task to a DTS package (Enterprise Manager)

To add a Bulk Insert task to a DTS package in DTS Designer

1. From the Connection toolbar, drag a Microsoft® OLE DB Provider for SQL Server connection onto the Data Transformation Services (DTS) design sheet and configure the connection.

   Note  The Bulk Insert Task requires one Microsoft OLE DB Provider for SQL Server connection. If such a connection is already configured in the package, you can skip Step 1.

2. From the Task toolbar, drag a Bulk Insert Task to the design sheet.

See Also

Bulk Insert Task