Overview
Destination data flow component, loading specified input into a dictionary object or Distributed Cache. You can use this with Lookup Plus component to cache lookup information.
Setup
The script has the following parameters:
- KeyColumn - input key column.
- ValueColumn - input value column.
- IsResultCache - indicates whether Result is stored in distributed cache.
- ResultVariable - variable used to store dictionary object.
- ResultCache - data is stored in distributed cache.
Configuration
To use this script, you would need to load it in COZYROC JavaScript Component. If you are using COZYROC SSIS+ 2.0 or later, after selecting the corresponding script type and opening the component editor, you can select the script from a dropdown list with the pre-built scripts. For COZYROC SSIS+ 1.9, you can download the JavaScript file and browse to it via the "Import JavaScript code" button.
Dictionary_Destination.jsKnowledge Base
COZYROC SSIS+ Components Suite is free for testing in your development environment.
A licensed version can be deployed on-premises, on Azure-SSIS IR and on COZYROC Cloud.