i had the same issue but take a look at the link it's a guide on how to handle import of Excel

http://microsoft-ssis.blogspot.dk/2012/09/swtich-package-from-64bit-to-32bit.html

.../simmy