SSIS flat file import - Issue with datetime format
Try adjusting your input column type to DT_DBTIMESTAMP2.  I've seen this fix similarly annoying Date conversion issues.  Here's a full list of what those input types mean.