In conditional split component, I need to know if Age equals -1 and am using following statement.
However, there comes errors when running. How should I modify my statement? Thx a loooooooot!!
Error: The expression "Age == -1" on "output "Unknown" (12743)" evaluated to NULL, but the "component "Age Conditional Split 1" (12740)" requires a Boolean results. Modify the error row disposition on the output to treat this result as False (Ignore Failure) or to redirect this row to the error output (Redirect Row). The expression results must be Boolean for a Conditional Split. A NULL expression result is an error.
Add a SSIS Conditional Split Transformation to the Data Flow The Conditional Split Transformation task checks for the specified condition. It moves the data to an appropriate destination depending upon the condition. Drag the SSIS Conditional Split task from the SSIS Toolbox.
The ISNULL() function can be used to find Null value rows. Step 3: Connect two Multicast Transformation to the Conditional Split Transformation, One Output NullRecords will be connect to one Multicast and default Output to second Multicast Transformation.
Scripting in the conditional split configuration needs the VBScript format. In the above configuration, three conditions are configured. In this configuration, the dataset is divided into three conditions.
A Conditional Split Transformation in SSIS is just like the IF condition or CASE statement. It checks the given condition and based on the condition result, the output will send to the appropriate destination path. It has ONE input and MANY outputs.
I am guessing that you have some NULL values for age. If you want to send NULL's to the same Unknown Output then you could change the expressions to be:
ISNULL(Age) || Age == -1
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With