No votes yet

Overview

Data flow transformation performing find-and-replace transformation in specified input columns using dictionary object. Each key from the dictionary is searched in the input column and if found replaced with the related value. The script has the following parameters:

  • InputColumns - selects list of columns to be transformed.
  • MapVariable - select variable containing mapping object. You can use the Dictionary Destination script to setup the object.
  • CaseSensitive - indicates whether the search is case-sensitive.

Requirements

Depends on COZYROC Script Component Plus for implementing parameters user interface.


Library references

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

ScriptMain

Leave a comment