In SSIS 2010, when I connect to an Excel Destination Task and select the 'Name of the Excel Sheet', I receive a 'No tables or views could be loaded' prompt, and then the below error message:
Steps I've taken through various Google/EE searches:
Installed Microsoft Access Database Engine 2010 Redistributable
Running the below code
but when I verify it returns this error message
Set the solution's Run64BitRuntime property to False.
Windows 7 Enterprise 64-bit, Visual Studio 2010 ??-bit, Office 2010 64-bit.
Thanks in advance.
Disclaimer: I've seen a TON of links on this, so if you can't answer the question without pasting a link, odds are you don't have enough experience to provide an answer.