DT_FILETIME [Result] 
Changes the time value represented by the DT_DBTIMESTAMPOFFSET data type to Coordinated Universal Time (UTC). Removes the fractional second value when its scale is greater than the number of fractional second digits that the DT_FILETIME data type can contain. After removing the fractional second value, generates a report about this data truncation. For more information, see Error Handling in Data.