Yesterday, I was playing with SSIS on my host machine and had bumped into an interesting error:
[Load Promotion Data ] Error: SSIS Error Code DTS_E_CANNOTACQUIRECONNECTIONFROMCONNECTIONMANAGER. The AcquireConnection method call to the connection manager "Excel Connection Manager" failed with error code 0xC00F9304. There may be error messages posted before this with more information on why the AcquireConnection method call failed.
[SSIS.Pipeline] Error: component "Load Promotion Data" (1) failed validation and returned error code 0xC020801C.
[Connection manager "Excel Connection Manager"] Error: SSIS Error Code DTS_E_OLEDB_EXCEL_NOT_SUPPORTED: The Excel Connection Manager is not supported in the 64-bit version of SSIS, as no OLE DB provider is available.
Now this looked interesting because I was on a x64 bit OS, x64 bit on SQL Server but had a x86 (32 bit) Office 2010 installed when I was using my Excel Data Source. These errors were taken as-is from the “Execution Result” tab directly. The errors give away some detail that this combo is the problem. But fundamentally various search yielded me into places which stated I need to run SSIS in a x86 mode. And this is well hidden inside the Project –> Properties tab –> Configuration Properties –> Debugging menu.
Just turn the “Run64BitRuntime” option to “False”. And go ahead with your build !!! This just solved my problem.
This entry was posted on Monday, November 29th, 2010 at 16:18 and is filed under Uncategorized. You can follow any responses to this entry through the RSS 2.0 feed. You can leave a response, or trackback from your own site.