Going out on a limb here and replying again. Take a sample of the spreadsheet, clean up the offending columns by replacing the & #13;& #10;& #13;& #10; (put a space after the & so you could see them in the post) with a space. Then use that file as a source to your SSIS package and see if it works.

Pretty sure that the html encoded carrage return/line feeds are your problem.