Hi,

You can do like this way.

Drag and drop a derived column task. Add new column with the conditional expression as:

([Column3]=="")?DT_DATE(NULL): (([column3]==".")?DT_DATE(NULL):[Column3])

In the DFT destination mapping use this new cloumn created...