Salesforce Source

Overview

Salesforce Source Component is SSIS Data Flow Component for consuming data from Salesforce Service. The configuration options are provided in the standard data flow source component dialog.

Setup

Use the options below to setup the component.

Options

SFORCE

Select an existing Salesforce connection manager.

Related Topics: Salesforce Connection Manager

BatchSize

Specify the number of rows to be retrieved as a batch. The maximum is 2000.

InputType

Specify input type. This property has the options listed in the following table.

Value	Description
Object	Input type is Salesforce object. Selecting this value displays the dynamic options Object.
Statement	Input type is SOQL statement. Selecting this value display the dynamic options Statement.

Note: After input change, you have to use Refresh command in the 'Column Mappings' tab to reload source object metadata.

Object

Select SalesForce data object.

Statement

Specify SOQL statement.

IncludeDeleted (1.4 SR-1)

Specify to include all records in result, including the deleted. This property has the options listed in the following table.

Value	Description
True	The deleted records are included in the result.
False	The deleted records are not included in the result.

How to modify source dynamically at runtime?

The source object or statement are 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 Source].[Statement]. This is the property containing the statement.
• Scroll-down and find Expressions property. Setup expression to modify the statement dynamically.