Results 1 to 1 of 1
February 11th, 2007, 06: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, 12:18 PM
By popdawg in forum Programming / Datafeeds / ToolsReplies: 4Last Post: March 4th, 2006, 12:25 AM
By Heyder in forum Midnight Cafe'Replies: 6Last Post: April 2nd, 2002, 10:43 AM