Hi Jim P.,

If you just follow the DTS Import Wizard in SQL 2000, use the text provider for the source (NOT EXCEL for CSV!!), point to your CSV file, then in the file format dialog, use delimited, text qualifier Double Quote, and First Column has column names if your file looks like your sample...

Then Specify the Comma as your comma delimiter, and you should see your sample rows. The Destination should already be pointing at the correct target database if you chose Import, so click next, and then click on the transform button, and make sure that you are using a VARCHAR(16) to handle up to Quadrillions. (And check the formats of your other columns...) Now make sure to save your DTS Job. I like to save it to the local server, and then from there save it as a VB file for advanced Manipulation.

(One trick is to create a small file as you did on your sample, create the DTS Package, then replace the small file with the large one, and rerun the package.) 

If you are planning to append rows on a regular basis, rerun the wizard after the small table was created, so that that the Append Rows choice is Checked, this will also remover the create table task form the job which will fail each time after the first...

Finally, DTS Jobs keep the context of the Machine running the tool, so, unless a file path is common to both the server and to the Machine used to create the DTS Package, you may receive errors if you try to run the package directly from the server. (If you schedule it for example.) So make sure that the CSV file can be seen by the server directly.

Hope this helps.

John R. Hanson