Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Help with a Bulk insert statement

Status
Not open for further replies.

Rene1024

MIS
Jul 24, 2003
142
0
0
US
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
 
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é
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top