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 recordsHere is the Salesforce destination configurationCan 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
Related Articles
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 ...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 ...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 ...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 ...How to increase the Data Flow Task Plus buffer size?
To increase the Data Flow Task buffer size please complete the following steps: 1) Right-click on the Data Flow Task and select Properties. 2) On the Data Flow Task's Properties screen under Misc find fields: DefaultBufferSize and ...