DEPRECATED: Starting with SSIS+ 1.9, the .NET scripts are no longer maintained. Use the provided JavaScript alternative scripts instead.
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.


Setup

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