MS Excel has no notion of data types. It is an electronic paper that allows any scribble. Everything is a text. That's why strongly typed environment like SSIS needs to guess what is ingested from MS Excel. And that guess is not always correct.
Your solution would be to add a Data Conversion Transformation between source and destination in the Data Flow Task.