SLAM_load_bulkv2

Overview

Provides a simplified approach to large data loads, allowing Salesforce to take a determining role in the orchestration of the job. Bulk v2 supports hardDelete

Note: For Bulk v2 operations, Speediful requires the @externalId parameter and it must be a real Salesforce field. This is essential to correlate the Salesforce result with the original input table.

Parameters

Name	Type	Default	Description
@sObject	NVARCHAR	Required	Salesforce object name to load data into
@table	NVARCHAR	Required	Input SQL table containing data to load
@operation	NVARCHAR	Required	Operation type ('insert', 'update', 'upsert', 'delete', 'hardDelete')
@externalId	NVARCHAR	Required	External ID field name (must be a real Salesforce field for result correlation). In the case of delete and hardDelete operations, use Id
@failure_threshold	DECIMAL(5,2)	100	Allowable failure rate (0-100) before throwing a SQL error. When 100, no error will be thrown

Usage Examples

Upsert Account records using external ID:

EXEC dbo.SLAM_load_bulkv2
    @sObject = 'Account',
    @table = 'Account_upsert',
    @operation = 'upsert',
    @externalId = 'Account_External_Id__c'

Delete Opportunity records:

EXEC dbo.SLAM_load_bulkv2
    @sObject = 'Opportunity',
    @table = 'Opportunity_delete',
    @operation = 'delete',
    @externalId = 'Id'