I have done research including threads on this forum but cant seem to find an answer.
I am loading text files with 40 columns. No transformation at this time. There are 8 files ~25MB with a total of 1,400,000 rows. Using Bulk Insert task the load completes in 3 minutes. Using OleDb destination and flat file input connection manager the load completes in 30 minutes.
From all I have read, SSIS should be using Bulk Inserts behind the OleDb connection. If so, why is there such a dramatic difference? I must be doing something wrong, any ideas?
Using all defaults for the connection. Table or View fast load. Blank rows per batch and max commit size 2,147,483,674. I am using Sql2016 but have had similar results testing with Sql2014.
