title: SSIS- OleDb Fast Load vs. Bulk Insert Task
body: <p>I have done research including threads on this forum but cant seem to find an answer.</p>
  
  <p>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.</p>
  
  <p>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?</p>
  
  <p>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.</p>