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.
C:\Program Files\Microsoft SQL Server\80\Tools\Devtools\Samples\Dts\Dtstasks\DTSBulkInsertTask
This sample assumes that you have created the pubs2..authors table as a copy of the pubs..authors table.