Overview
Data flow transformation for handling NULL values, either by replacing them with given value, or by setting a NULL when a given regular expression is matched. Both modes can be run simultaneously, and both can retrieve the corresponding reference values, either directly from a component's parameter, or from a provided SSIS variable.
Setup
The script has the following parameters:
- InputColumns - one or more input columns to be inspected.
- ReplaceAction - what action to be taken, when a NULL value is found in the provided input columns. Possible values are
None, Value or Variable. The first one disabled this functionality, the other two values determine the source of the replacement value.
- ReplaceValue - if the action is set to
Value , this one specifies the replacement value explicitly.
- ReplaceVariable - if the action is set to
Variable, the replacement value is retrieved from the provided SSIS variable.
- MatchAction - whether to search for a provided value and replace matching columns with
NULL. Possible choices are None, Value or Variable. The first one disabled this functionality, the other two values determine the source of the matching regular expression.
- MatchValue - if the action is set to
Value , this one specifies the regular expression to be matched explicitly.
- MatchVariable - if the action is set to
Variable, the regular expression is retrieved from the provided SSIS variable.
