Firstly, Excel and SSIS will put you in a world of pain. Do you really need to use Excel as a source or destination. If you have another option I would seriously consider it.

Secondly, Are you getting the error in your development environment or when you deploy the package and run in dtsExec.

Which version of SQL are you on

Which version of BIDS/SSDT are you using

Which version of Excel is on your development machince

Which version of Excel was used to create the file

Which version of Excel is on your SSIS server

Is your development machine 32 or 64 bit

Is your SSIS server 32 or 64 bit

Is any part of the spreadsheet protected