DEPRECATED: Starting with SSIS+ 1.9, the .NET scripts are no longer maintained. Use the provided JavaScript alternative scripts instead.
Script File:
Overview
Data flow transformation, performing lookup against Dynamics CRM service.
Setup
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.
Requirements
Depends on COZYROC Script Component Plus component for implementing parameters user interface.
Requires installation of COZYROC SSIS+ 1.5 library.