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!