Using Bulk Load for Single Inserts/Updates/Deletes (Salesforce Driver)
When the EnableBulkLoad property is set to true, the Salesforce driver uses the Salesforce Bulk API for single Insert, Update, and Delete statements if the number of rows affected by the operation exceeds the threshold set by the BulkLoadThreshold connection property. For example, if you set the EnableBulkLoad property to true and the BulkLoadThreshold property to 2000, executing the following statement would use the Bulk API if the number of rows returned by SELECT rowid, sys_name FROM account is more than 2000 rows.
INSERT INTO tmpAccounts(accountId, accountName) SELECT rowid, sys_name FROM account