Regular Expression Transformation 1.0.0.41

The regular expression transformation exposes the power of regular expression matching within the pipeline. One or more columns can be selected, and for each column an individual expression can be applied.

If all columns selected pass their tests then rows will be passed down the successful match output. Rows that fail to pass all tests are directed down the alternate output.

This transformation is ideal for validating data through the use of regular expressions. You can enter any expression you like, or select a pre-configured expression within the editor.

You can expand the list of pre-configured expressions yourself. These are stored in a Xml file, %ProgramFiles%Microsoft SQL Server90DTSPipelineComponentsRegExTransform.xml.