SSIS and Excel import
You'll need to configure SSIS to run in 32-bit runtime as Excel does not support 64-bit

Go to the Property page for the Solution, select Debugging and change Run64BitRuntime to False

Running 32-bit SSIS in a 64-bit Environment