Handling null values with Conditional Split in SSIS

Question

Hello, community.

I am using Conditional Split in SSIS. I need to handle null values. If a null value appears, I just want to ignore it and the flow to continue.

I have some conditions:

1. MyColumn == "String"
2. ISNULL(MyColumn) --> The expression on "Conditional Split.Outputs evaluated to NULL, but the "Conditional Split" requires a Boolean results. 
3. Everything else (Conditional Split Default Output).

Thanks in advanced.

Regards,

Answer 1

Hi @Geraldo Peralta,

Try with below:

1. REPLACENULL([MyColumn],0) == "String"
2. ISNULL(MyColumn) -->
3. Everything else (Conditional Split Default Output).

And then connect case1 and default output to next steps.

Regards，

Zoe Hui

---

If the answer is helpful, please click "Accept Answer" and upvote it.

Answer 2

Try to use the ISNULL function along with the logical OR operator (||) to create a condition that checks for both null values and the desired condition you want to have.

• You can create a condition with the expression MyColumn == "String"
• Then create a second condition with the expression ISNULL(MyColumn) || MyColumn == "" : The ISNULL function checks if MyColumn is null. If it is, the expression evaluates to true and the flow continues. If MyColumn is not null, the expression moves to the logical OR operator, which checks if MyColumn is an empty string (""). If it is, the expression evaluates to true and the flow continues. If MyColumn is neither null nor an empty string, the expression evaluates to false and the flow goes to the default output.
• Else (Conditional Split Default Output): The default output should be connected to the next step in the data flow.