No votes yet


Overview

Data flow transformation, extracting elements from specified input using regular expression. The groups specified in the regular expression are setup as output data flow columns and populated appropriately.


Setup

The script has the following parameters:

  • Column - selects input data flow column.
  • Pattern - specifies regular expression used for extraction.

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