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, directing input rows to match or no match outputs based on specified regular expression.


Setup

The script has the following parameters:

  • Column - specifies the input column to use in the regular expression.
  • Pattern - specifies regular expression pattern.
  • IgnoreCase - specifies to do case-insensitive matching.
  • Multiline - specifies to use multiline mode.

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