CozyRoc
Overview
Salesforce Destination Component is SSIS Data Flow Component for loading data into Salesforce object. The configuration options are provided in the standard data flow destination component dialog.
Setup
Use the options below to setup the component.
Options
- SFORCE
-
Select an existing Salesforce connection manager.
Related Topics: Salesforce Connection Manager
- Action (1.4 SR-2)
-
Select destination object action. This property has the options listed in the following table.
Action Description Create Create new record in the destination object. Update Update existing record in the destination object. You have to specify the appropriate object record identifier for the update to work. Delete Delete existing record from the destination object. You have to specify the appropriate object record identifier for the delete to work. Upsert (1.4 SR-3) Update and insert record in the destination object. Selecting this value display the dynamic option ExternalId. Note: After action change, you have to use Refresh command in the 'Column Mappings' tab to reload destination object metadata.
- BatchSize
-
Specify the number of rows to be sent as a batch. The maximum is 200.
- DestinationObject
-
Specify the destination Salesforce object where the data is loaded.
- ExternalId (1.4 SR-3)
-
Specify field for external identifiers used in the upsert action.
- ErrorRowDisposition (Salesforce Destination Input)
-
Specify how to handle rows with errors.
How to modify destination object dynamically at runtime?
The destination object is available in the data flow properties list. Follow these steps to setup expression:
- Right-click on data flow canvas and select Properties menu.
- Scroll-down and find property named like [Salesforce Destination].[DestinationObject]. This is the property containing the destination table.
- Scroll-down and find Expressions property. Setup expression to modify the statement dynamically.
