• 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