Average: 4.3 (3 votes)

Overview

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.

Demonstration

You can download a sample package demonstrating the script from here.


Requirements

Depends on COZYROC Script Component Plus for implementing parameters user interface.
Requires installation of COZYROC SSIS+ 1.4 SR-1 library.


Library references

  • System
  • System.Data
  • Microsoft.SqlServer.TxScript
  • Microsoft.SqlServer.PipelineHost
  • Microsoft.SqlServer.DTSPipelineWrap
  • Microsoft.SqlServer.DTSRuntimeWrap
  • Microsoft.SqlServer.ManagedDTS
  • CozyRoc.SSISPlus

ScriptMain


RangeDictionary

Leave a comment