SQL Server 2000

This Microsoft® Visual Basic® sample demonstrates how to use Data Transformation Services (DTS) to perform a bulk insert operation from a flat text file. Bulk insert operations are possible from a wide range of OLE DB provider file types.

Default Location

C:\Program Files\Microsoft SQL Server\80\Tools\Devtools\Samples\Dts\Dtstasks\DTSBulkInsertTask

Running the Sample
  1. Open the BulkInsertTask.vbp project.

  2. Run the application.

This sample assumes that you have created the pubs2..authors table as a copy of the pubs..authors table.

See Also

DTS Programming Samples

© 2015 Microsoft