Results 1 to 1 of 1
February 11th, 2007, 05:45 AM #1
how to speed bulk insert to sql?
- Join Date
- January 22nd, 2007
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) & "')"
By Acemck in forum Introduce YourselfReplies: 2Last Post: August 4th, 2011, 11:18 AM
By popdawg in forum Programming / Datafeeds / ToolsReplies: 4Last Post: March 3rd, 2006, 11:25 PM
By Heyder in forum Midnight Cafe'Replies: 6Last Post: April 2nd, 2002, 09:43 AM