Question

Zoe.Ohara on Thu, 15 Nov 2012 09:46:51


Hi,

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?

Thanks,

Zoe


Sponsored



Replies

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.

Thank you!

KingOfCatan on Thu, 08 Dec 2016 16:15:22


Ditto!  That saved me a heap of headaches!