Failed to acquire connection

[grnzbra]

I have an SSIS package that has an Excel connection manager which is used by an Execute SQL task and then passes the results on to other steps.
When I run this on my development machine, it runs fine. However, when the testers attempt to run it on the test machine, the Execute SQL task fails with the following errors showing up in the Execution Results tab.

[Execute SQL Task] Error: Failed to acquire connection "Excel Connection Manager". Connection may not be configured correctly or you may not have the right permissions on this connection.

[Connection manager "Excel Connection Manager"] Error: SSIS Error Code DTS_E_OLEDBERROR. An OLE DB error has occurred. Error code: 0x80004002. An OLE DB record is available. Source: "Microsoft OLE DB Service Components" Hresult: 0x80004002 Description: "No such interface supported".

It seems that there must be some difference between the machines, but no one has any idea what. What might cause this to happen?

 

[dhulbert]

Is the same person running it on both machines?
If not try running it with the same person on both machines to ensure the issue is with the machines not with access permissions for the user.

I love deadlines. I like the whooshing sound they make as they fly by
Douglas Adams
(1952-2001)