Hi All, I need to use IF statment in DErived COulmn. If Product_Type = 'PL' then the New column shld be populated with 'SD' else if it is null it shld be populated with 'LD'. Kindly help. REgards, James.

Open Deriv col: and put this below exp there. (Product_Type == 'PL' ?"SD":ISNULL(Product_Type)?"LD") I did not tested this. But let me know how this goes.

hello James, You must use the SSIS Expression equivalent boolean_test ? true_result : false_result So it would look like Product_Type = "PL" ? "SD" : ISNULL(Product_Type) ? "LD" : false_result then what? I do not know, insert yours Arthur My Blog

Thanks Guys..It worked like a charm :-)