Zoe.Ohara on Thu, 15 Nov 2012 09:46:51
I have a SSIS package that runs ok when Im running from any desktop. (It works in BIDS and SSMS)
But when I log onto the server (with the same account) - SQL Server 2008 R2 - I get an error
SSIS Error Code DTS_E_CANNOTACQUIRECONNECTIONFROMCONNECTIONMANAGER. The AcquireConnection method call to the connection manager "Excel Connection Manager" failed with error code 0xC0202009
I get this on the server in BIDS, SSMS and when running from an agent job.
Any ideas what this might be?
RohitGarg on Thu, 15 Nov 2012 10:10:12
What is the extention of excel .xls or xlsx ?
what is the bit version of excel , SQL BIDS & windows ? It seems to be issue of 32 & 64 bit.
Zoe.Ohara on Thu, 15 Nov 2012 11:01:04
That was it! it was running the package in 64 bit mode.
KingOfCatan on Thu, 08 Dec 2016 16:15:22
Ditto! That saved me a heap of headaches!