No votes yet


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.


The script has the following parameters:

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


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