SSIS Conditional Split boolean result

ssis split conditional boolean-expression
Echo picture Echo · Aug 23, 2012 · Viewed 12.8k times · Source

In conditional split component, I need to know if Age equals -1 and am using following statement. enter image description here

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.

Answer

SQLMD picture SQLMD · Aug 23, 2012

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

Related questions

How to pass variable as a parameter in Execute SQL Task SSIS?

I have ssis package in that I'm taking values from flat file and insert it into table. I have taken one Execute SQL Task in that creating one temptable CREATE TABLE [tempdb].dbo.##temptable ( date datetime, companyname nvarchar(50), price decimal(10,0), …

Read More
SSIS Convert Between Unicode and Non-Unicode Error

I have an ssis package where I am using an OLEDB source linking to SQL Server 2005 table. All columns except a date column are NVARCHAR(255). I am using an Excel destination and using a SQL statement to create the sheet …

Read More
What is the SSIS package and what does it do?

Can someone tell me what the SSIS package is all about? I am totally new to data-warehousing and I am going crazy with the terms SSIS, DTL, ETL and so on. I am looking for a big picture and how …

Read More