Category: sql server ssis


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.

Thank you!

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

Ditto!  That saved me a heap of headaches!