SSIS - Running packages on 64-bit computers

If you need to run a SQL Server 2008 R2 package in a 64-bit computer, and you are having trouble because the connection to an Excel 2010/2007 file is not working, read this article.

In short...

In the Project Properties of an Integration Services package, you can select 32-bit or 64-bit execution by setting the value of the Run64BitRuntime property on the Debugging page. By default, the value of this property is True. When the 64-bit version of the Integration Services runtime is not installed, this setting is ignored.