Create a load table
This example creates a load table called "Account_TestLoad_Insert". The Id and Error columns are mandatory, as this is an Insert there is nothing to add into Id, but it needs to be provided, as the resultant created record Id will be passed back on creation. All load operations require the Error column, whether success or failure, to guide and inform you.
drop table if exists Account_TestLoad_Insert
create table Account_TestLoad_Insert
(Id nchar(18)
,Error nvarchar(255)
,Name nvarchar(255))
insert Account_TestLoad_Insert
(Name)
select 'Test1 for SQL-Sales'
union select 'Test2 for SQL-Sales'
Running the example
exec ss_Loader 'Insert','DEMO','Account_TestLoad_Insert'
SQL-SALES Insert run date: 2023-11-04 ---------------------------
18:35:30: Using Env|Schema: DEMO|dbo
18:35:30: Starting Loader for Account batchsize 200
18:35:30: SSId added to Account_TestLoad_Insert
18:35:33: Connection method BULK & SOAP API
18:35:33: Columns checked against Salesforce metadata
18:35:38: Load complete: Success:2 Failure:0
-----------------------------------------------------------------
As described, the created Id for the insert(s) will be passed back to the load table
