Data flow transformation, performing lookup against Dynamics CRM service.
The script has the following parameters:
- CrmConnection - selects COZYROC Dynamics CRM connection.
- Entity - selects Dynamics CRM entity.
- KeyAttribute - selects one or more entity key attributes. After you select the attributes, you have to map your input columns to the key attributes in the Mappings tab.
- ValueAttribute - selects one or more lookup value attributes.
- UseCache - specify whether you want to use in-memory caching. Default is false.
Depends on COZYROC Script Component Plus component for implementing parameters user interface.
Requires installation of COZYROC SSIS+ 1.5 library.