Average: 5 (2 votes)


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.


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.


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

Library references

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