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