INSERT calls SF_TableLoader to

• read each row of the Input table
• match the columns to the fields of the Salesforce object
• attempt to insert the new object into Salesforce

Note that SF_TableLoader attempts to insert all rows of the load table regardless of any existing values in the ID column. In other words, this column is ignored on input when doing an Insert operation.

After execution of SF_TableLoader, the ID column of the Result table is overwritten with the ID assigned by Salesforce for each successfully inserted row. If the row could not be inserted, the Error column in the Result table contains an error message for the failure.