hello, I am comparing source(SQL 2008 r2) and destination(DB2) in conditional split and I am dividing data in to matched and no matched outputs, when both source and destination columns are empty strings it must deviate to matched output but even though both are empty strings its showing as unmatched output, is there any way that I can resolve this issue?

Hello, Please TRIM both columns and it will match, if there are Null then Replace NULL with "". Thankshttp://sqlage.blogspot.com/

Indeed try something like Aamir suggested: (ISNULL([Column1]) ? "" : TRIM([Column1])) == (ISNULL([Column2]) ? "" : TRIM([Column2]))Please mark the post as answered if it answers your question | My SSIS Blog: http://microsoft-ssis.blogspot.com

HI Please try using the Below Expression TRIM(ColumnName)=="" ? (DT_STR, 4, 1252)NULL(DT_STR, 4, 1252) : ColumnName OR ISNULL(ColumnName)||TRIM(ColumnName)==""?"Unknown": ColumnName Regards ========================= Naveen Kumar Thangaraj Naveen Kumar

thanks for all of you guys thanks Sam