Data flow destination, creating custom-crafted IDictionary object. The created dictionary object is a more memory-efficient representation of "many to one" relationships and can be used in the Lookup Plus component to perform lookups.
The script has the following parameters:
- StartColumn - select input column containing range start.
- EndColumn - select input column containing range end.
- ValueColumn - select input column containing range value.
- ResultVariable - select package variable to store custom range dictionary.
You can download a sample package demonstrating the script from here.
Depends on COZYROC Script Component Plus for implementing parameters user interface.
Requires installation of COZYROC SSIS+ 1.4 SR-1 library.