No votes yet

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. It 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.


Library references

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

ScriptMain

Leave a comment