Salesforce Destination

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.

Id (Salesforce Destination Error Output) (1.4 SR-4)

Contains the unique identifier of the added, updated or deleted record.

RelationshipName (Salesforce Destination Input -> External Column) (1.5 SR-2)

Specify relationship name for updating foreign key lookup with external identifier.

ReferenceType (Salesforce Destination Input -> External Column) (1.5 SR-2)

Specify referenced object for updating foreign key lookup with external identifier.

ExternalId (Salesforce Destination Input -> External Column) (1.5 SR-2)

Specify external identifier field for updating foreign key lookup with external identifier.

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.

How to find which records contain error?

The component's Error Output is used for providing both error information and processed record identifier. Check ErrorCode column:

You can setup standard Conditional Split component to filter non-error records.