Search Suggest

REGEX
REGEX

Custom SSIS Component: Foreach File Enumerator with regex

In some cases the standard wildcard filter in the Foreach File Enumerator isn't flexible enough. Try to get all files ending with a number or all…

Regex filter for Foreach Loop

Case The standard Foreach Loop File Enumerator only has a wildcard filter, but in some cases a regular expression filter would be more useful. See/v…

Cleaning with Regular Expressions in SSIS

Case I have a column with html tags in the value. How can I remove those tags? Solution You could try the make an expression in a derived column, but…

Regular Expressions in SSIS

Case I want to use a Regular Expression to filter incorrect emailaddresses in SSIS. Solution There are a couple of options: Microsoft built a SSIS Sa…