Average: 5 (1 vote)


Overview

Data flow transformation, creating Soundex representation of input column. Soundex is a phonetic algorithm for indexing names by sound, as pronounced in English.


Setup

The script has the following parameters:

  • InputColumn - specifies column for algorithm input.

The result representation is stored in output column named Soundex.


Requirements

Depends on COZYROC Script Component Plus for implementing parameters user interface.
Requires installation of COZYROC SSIS+ 1.4 library.


Library references

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

ScriptMain