Data flow transformation, performing lookup against Salesforce service. The script has the following parameters:
- Connection – selects COZYROC Salesforce connection.
- SalesforceObject – selects Salesforce object.
- KeyField – selects one or more object key fields. After you select the fields, you have to map your input columns to the key fields in the Mappings tab.
- ValueField – selects one or more lookup value fields.
- UseCache – specify whether you want to use in-memory caching. Default is true.
Depends on COZYROC Script Component Plus component for implementing parameters user interface.
Requires installation of COZYROC SSIS+ 1.4 library.