If definitely the second case scenario.

When loading the data manually through the SSMS import wizard all the rows and columns line up.

So yes its definitely mapping incorrectly.

Is there any way of auditing files through SSIS?