SSIS- OleDb Fast Load vs. Bulk Insert Task -
i have done research including threads on forum cant seem find answer.
i loading text files 40 columns. no transformation @ time. there 8 files ~25mb total of 1,400,000 rows. using bulk insert task load completes in 3 minutes. using oledb destination , flat file input connection manager load completes in 30 minutes.
from have read, ssis should using bulk inserts behind oledb connection. if so, why there such dramatic difference? must doing wrong, ideas?
using defaults connection. table or view fast load. blank rows per batch , max commit size 2,147,483,674. using sql2016 have had similar results testing sql2014.
you might not setting properties of data flow task such defaultbuffersize , defaultbuffermaxrows.
Comments
Post a Comment