This answer explains why the milliseconds part is removed when passing a DateTime value as a parameter in a OLE DB source SQL Command. Besides, it explains the different data types systems used in SSIS.