Row per batch option in oledb destination in SSIS

This option is enabled when we are selecting Data access mode to “Table or view – fast load”

   

 

The default value for this field is blank which specifies all incoming rows will be treated as a single batch. We can change this default behavior and break all incoming rows into multiple batches. The allowed value is an only positive integer which specifies the maximum number of rows in a batch.

Suppose in our incoming file has approx. 100k rows, in this case, we can create 10 batches 10k each.