Does the Waiting column have mixed data types, some numeric, some text? You many be running into an issue where SSIS thinks the data should be one type and in reality it is not.

Maybe check out:

http://microsoft-ssis.blogspot.com/2011/06/mixed-data-types-in-excel-column.html