Jeff,
I have one more question.
I have a derived column expression like this :
LTRIM(Column1) == "" ? (DT_STR,100,1252)NULL(DT_STR,100,1252)
(Column1== "Y" ) ? 1 : 0
This Column1 is a 'BIT' datatype. So I have to write an expression for validating :if the Column1 comes with empty string replace it with 'NULL' and if it comes as "Y" then 1 else 0
Those above expression works well independently.
How to write this two condition in a single expression??
Please help.
Thanks