Regular Expression Transformation

Regular Expression Transformation exposes the power of regular expression matching within the pipeline
Download

Regular Expression Transformation Ranking & Summary

Advertisement

  • Rating:
  • License:
  • Freeware
  • Publisher Name:
  • Konesans Ltd
  • Operating Systems:
  • Windows All
  • File Size:
  • 575 KB

Regular Expression Transformation Tags


Regular Expression Transformation Description

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. Requirements: · SQL Server 2005 Integration Services


Regular Expression Transformation Related Software