Thanks a lot @billinkc. I will go over it. I did sthg like this to handle and it seems like its working it. ([Drv DOB] == "0") || ([Drv DOB] == "101") ? NULL(DT_DBTIMESTAMP) : (DT_DBTIMESTAMP)(SUBSTRING([Drv DOB],1,2) + "-" + SUBSTRING([Drv DOB],3,2) + "-" + SUBSTRING([Drv DOB],5,2)) . It handles 0 and 101 effectively and as well as output the right format for DOB. —
apariyar 10 mins ago