• Correcting at the source is most logical thing.

    But, on the other hand you can validate your flat file before loading data into database. You load the good data into table. You can send the invalid data for correction or may be correct it using a utility. Here is something you can try (if you want)

    SSIS: How to validate Flat File Row Length?

    Vikash Kumar Singh || www.singhvikash.in