Setting the Batch Size with SF_TableLoader


Setting the Batch Size with SF_TableLoader


SF_TableLoader with the soap switch uses a default batch size of 200 rows (SOAP API). When using the bulkapi, it uses a default batch size of 10,000. If you need to reduce the batch size, use batchsize(𝘹𝘹).

For example, to set the batch size to 50:

 EXEC SF_TableLoader 'Update:soap,batchsize(50)','Salesforce','User_Upd'

 EXEC SF_TableLoader 'Update:batchsize(50)','Salesforce','User_Upd'

NOTE: The batchsize option is ignored if SF_TableLoader uses BulkAPI2.