Map Replace Transformation

Your rating: None Average: 2 (2 votes)

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 component 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