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