A follow-up question ...
If VS is running as 32-bit, why do I need to set Run64BitRuntime to False? If I don't I get the following error:
The requested OLE DB provider Microsoft.ACE.OLEDB.12.0 is not registered. If the 64-bit driver is not installed, run the package in 32-bit mode...
My Environment
Windows 8
VS 2010 shell
SSDT
Excel 2007 Workbook
Thanks!
www.sqlwithcindy.com