DEPRECATED: Starting with SSIS+ 1.9, the .NET scripts are no longer maintained. Use the provided JavaScript alternative scripts instead.
Script File:
Overview
Data flow transformation for handling NULL values.
Setup
The script has the following parameters:
- InputColumns - selects one or more input columns for processing.
- Action - selects component action.
-
- IsNull - Replaces NULL input with ReplaceValue.
-
- SetNull - Sets NULL where input value equals MatchValue.
- IsReplaceValueVariable - indicates whether the replace value is stored in a variable.
-
- ReplaceValue - specifies replace value.
-
- ReplaceValueVariable - selects variable containing replace value.
- IsMatchValueVariable - indicates whether the match value is stored in a variable.
-
- MatchValue - specifies match value.
-
- MatchValueVariable - selects variable containing match value.
Requirements
Depends on COZYROC Script Component Plus for implementing parameters user interface.