SSIS mysterious error

I agree with the answer above "files were older and had some columns missing in the header" (and I upvoted this answer). I just had the same error, and after investigation it was because the external flat file had a column missing, compared to the columns expected by the flat file connection manager. In essence, the SSIS error "An error occurred while skipping data rows" should be interpreted as meaning "Check the actual columns in the flat file source match the columns defined in its connection manager".


Ah i found it... files were older and had some columns missing in the header..........