It sounds like a data-driven error. Check the data types on your Excel Source to make sure they match the columns they are mapped to in the Excel file. In the files that fail, check for rows of data where the data in a particular cell might be much longer than all the other cells.
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato