Script Salesforce Lookup Transformation
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.
Ready to give it a try?
COZYROC SSIS+ Components Suite is free for testing in your development environment.