
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.
- 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.
CozyRoc