Script File:
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
