Dictionary Destination

Your rating: None Average: 3.3 (3 votes)

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