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'