Help with a Bulk insert statement

[Rene1024]

Hi,

I need to import a large .txt file into my SQL 2000 server, when i try using the wizard in Enterprise Manager i get an error when i reach the 7.5 million record mark. The error i get is the following:
"Not enough storage is available to process this command"
I have plenty of hard drive space on the server to import the file. The file is "Tab delimited" with "LF" row delimiter, I tried the following statement, but i need help with the correct syntax for the delimiter information.
"BULK INSERT table name FROM file name WITH (FIELDTERMANATOR = ',')

Thank you in advance for any help you can provide.

Best regards,

Rene

 

[drlex]

What's the recovery model on your DB? If you don't want to change it, can you try importing the data into a new database with bulk logged recovery? (See BOL if necessary regarding recovery modes).
Have you tried with specifying the batch size in the bulk insert command - say 50,000?

soi là, soi carré