i need to bulk to sql more then 10 giga of data
i have a storeprocedure that cutting the file into small pieces - like 21000 rows
(because the file are huge - and sql can not handel a bulk of 2 giga file)

i am using the bulk - and its take me like 40,000 item per minut
HOW can i speed this bulk?

my bulk str is like :


strsql="BULK INSERT tempImport FROM '" & filename & " ' WITH (FIELDTERMINATOR ='" & FIELDTR & "',MAXERRORS=1000 , FIRSTROW=1,LASTROW=" & last_row & ",ROWTERMINATOR ='" & chr(10) & "')"