SSIS - Insert Bulk How many Rows per batch to choose?
<p>I'm using <strong>bulk insert</strong> in <strong>SSIS</strong> to fill a table with approx 10M rows in SQL Server.
I've googled a lot about it, and still could not find an answer for it.</p>

<p>How many <strong>Rows per batch</strong> should I choose? 
How many <strong>Maximum insert commit size</strong> should I choose?</p>

<p>It would be great to receive an explanation about each one.</p>

<p>I've tested it and changed the <strong>Rows per batch</strong>. The best result I've received so far is for 5M.</p>

<p>Appreciate your help!</p>