Cindy Conway-312336 (3/28/2013)
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!
Not 100% sure, but I think the debugging environment (not the same as the design environment) mimics a 64-bit environment. If a 64-bit provider is not present - such as the ACE OLE DB provider most of the time - you need to set the Run64BitRuntime property to false.
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP