You might need to change the project properties in SSIS. In the project drop down, click project properties at the bottom. Under Configuration Properties click on Debugging. Change the Run64BitRuntime to False.

Not sure if this will solve your problem, but it helped me out when I was having trouble with an Excel connection before.