DSXchange

Cherukuri,
use a execute command stage first with command ->date +%H:%M:%S.$(( $(date +%N) / 1000000 ))
if you want to set this as parameter to other activity stages - use command output of execute command stage.
Let me know if this works

I am glad its working,
Lets say your source column have a value , space and null coming then this should solve

If IsNull(Ln_in.col_2) Or Trim(Ln_in.col_2)='' Then SetNull() Else StringToDate(Ln_in.col_2,"%yyyy-%mm-%dd")