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…