DEPRECATED: Starting with SSIS+ 1.9, the .NET scripts are no longer maintained. Use the provided JavaScript alternative scripts instead.
Script File:
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.
Requirements
Depends on COZYROC Script Component Plus component for implementing parameters user interface.
Requires installation of COZYROC SSIS+ 1.5 SR-1 library.