I'm getting the following error on the code below which is an expression in a conditional split. Is there another way I can write the code to avoid the error? ((ISNULL((DT_WSTR,20)Personal_Stmnt_Dt) ? "" : (DT_WSTR,20)Personal_Stmnt_Dt) != (ISNULL((DT_WSTR,20)dest2_Personal_Stmnt_Dt) ? "" : (DT_WSTR,20)Personal_Stmnt_Dt)) "Changed" (8377)" evaluated to NULL, but the "component "Conditional Split" (473)" 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. LISA86

tell us what you want to do? in the conditional split task, result of expression should be true or false ( as error said exactly ), this is because of that conditional split should separate rows with false result with rows with true result. If you have a logic which you want to split your data stream rows , use conditional split. but if you want to replace a column value with an expression or create new columns based on other columns values and expression use Derived Column Transformation. If this doesn't make sense to you tell us what exactly you want to do?http://www.rad.pasfu.com

It's actually an incremental build. I'm comparing the existing data to the new data coming in. In this case the personal_stmnt_dt was '2008-12-02' and is now NULL. I will then created a new row in the dimension with the null value. ((ISNULL((DT_WSTR,20)Personal_Stmnt_Dt) ? "" : (DT_WSTR,20)Personal_Stmnt_Dt) != (ISNULL((DT_WSTR,20)dest2_Personal_Stmnt_Dt) ? "" : (DT_WSTR,20)Personal_Stmnt_Dt))LISA86

I have figured it out. It was my code.LISA86