• Hi peter,

    Source file is flatfile.

    and i implement following expression in derived column.

    ([datestring ] == "0") ? (DT_DBTIMESTAMP)0 : (DT_DBTIMESTAMP)(SUBSTRING([datestring ],1,4) + "-" + SUBSTRING([datestring ],5,2) + "-" + SUBSTRING([datestring ],7,2))

    its working fine but at destination in "0" place it display "12/30/1899 12:00:00" but i want display "0" only

    Thanks

    murali