SF_Generate


SF_Generate


Usage

SF_Generate generates an empty local table that you can use as the input to SF_BulkOps for the operation specified. All columns of the Salesforce object that are valid for the operation are included in the table. The Input table name must begin with a valid Salesforce object name followed by an underscore and suffix. For example, Account_Load and Account_FromWeb are valid Input table names. XXX_Load is not a valid Input table name (“XXX” is not a valid Salesforce object).

SF_Generate requires that you specify an operation of ‘Insert’,’Update’,’Upsert’, or ‘Delete’. The local table generated has all columns that are valid for that operation.

Syntax

 EXEC SF_Generate 'op','𝘭𝘪𝘯𝘬𝘦𝘥_𝘴𝘦𝘳𝘷𝘦𝘳', 'local_table'

where op is ‘Insert’,’Update’,’Upsert’ or ‘Delete’; linked_server is your linked server name; and local_table is the local Input table name.

Example

This example creates a local table named Account_Load for the Salesforce Accountobject using the SALESFORCE linked server.

 EXEC SF_Generate 'Insert','SALESFORCE','Account_Load'