Why is the batch size in my Salesforce bulk data load different than the batch size I set?

Why is the batch size in my Salesforce bulk data load different than the batch size I set?


Scenario:
We are doing bulk data load to Salesforce and the default size which we have set is 10000 but when i look at the Salesforce the number of records are processing per batch is 112 records


Here is the Salesforce destination configuration

 Can you please let me know why is it processing only 100+ records at a time when i have set batch size to 10000. Because of this to just load 20000 records it is taking around 5 minutes.  Can you please help us with this data load to become faster
Solution:
The size/length of your rows exceed the default SSIS buffer size.  You will need to manipulate the default DefaultBufferMaxRows and DefaultBufferSize to experiment what numbers will work for your particular data set and to be able to send a batch of 10000 rows.  Also, there is a AutoAdjustBufferSize that may or may not work for you if set to True, but if it doesn't work for your data set then you need to manually adjust for your needs.

    Book a Presales Call


    Are you new to COZYROC and evaluating our solutions? 
    Book a Presales Call with us now and get 5% off SSIS+.