Script RegEx Match Transformation
Data flow transformation, directing all input rows to either Match or No match outputs, based on matching with a specified regular expression.
The script has the following parameters:
- MatchColumns - the input columns to use for regular expression searching. Finding a match in any of the columns sends the row to Match output.
- Pattern - the regular expression pattern to be used.
- IgnoreCase - perform a case-insensitive matching.
- Multiline - make a per-line matching, i.e. treat
$per each line, as opposed to the whole input.
Ready to give it a try?
COZYROC SSIS+ Components Suite is free for testing in your development environment.