Cannot Acquire Excel Connection

• mitzyturbo

  Hall of Fame

  Points: 3452

  More actions

  November 18, 2013 at 8:47 am

  #286427

  Hi guys,

  Hoping someone can help me out with an issue. I have a package that is a step in a SQL job. The job agent is running under local system account, the job step is set to run under a proxy, my own, which succeeds. The package sets the excel file paths at run time in variables based off a configuration table.

  However, under another proxy which runs under a different credential the job does not run. The user in question has the same server access as me, the only difference is that his proxy has more subsystem access than me, I only have SQL Server Integration Services Package.

  If the user in question runs the package locally on his own machine it works correctly. But running as a proxy using his credential it fails as a job on the server.

  Error message below:

  Executed as user: xxx\yyy. Microsoft (R) SQL Server Execute Package Utility Version 10.50.4000.0 for 32-bit Copyright (C) Microsoft Corporation 2010. All rights reserved. Started: 08:30:39 Error: 2013-11-18 08:30:40.73 Code: 0xC0202009 Source: CCMADiallerExceptions Connection manager "Excel Connection Manager" Description: SSIS Error Code DTS_E_OLEDBERROR. An OLE DB error has occurred. Error code: 0x80004005. An OLE DB record is available. Source: "Microsoft JET Database Engine" Hresult: 0x80004005 Description: "Unspecified error". End Error Error: 2013-11-18 08:30:40.74 Code: 0xC020801C Source: Summary Details Summary Section [46] Description: SSIS Error Code DTS_E_CANNOTACQUIRECONNECTIONFROMCONNECTIONMANAGER. The AcquireConnection method call to the connection manager "Excel Connection Manager" failed with error code 0xC0202009. There may be error messages posted before this with more information on why the AcquireConnection method call failed. End Error Error: 2013-11-18 08:30:40.74 Code: 0xC0047017 Source: Summary Details SSIS.Pipeline Description: component "Summary Section" (46) failed validation and returned error code 0xC020801C. End Error Error: 2013-11-18 08:30:40.74 Code: 0xC004700C Source: Summary Details SSIS.Pipeline Description: One or more component failed validation. End Error Error: 2013-11-18 08:30:40.74 Code: 0xC0024107 Source: Summary Details Description: There were errors during task validation. End Error DTExec: The package execution returned DTSER_FAILURE (1). Started: 08:30:39 Finished: 08:30:40 Elapsed: 1.469 seconds. The package execution failed. The step failed.

  Just to make sure I'm not going mad, I tried this under another proxy with the same server access as mine which did not get this error.

  We're all using 32 bit machines so I'm really at a loss as to why this error is being thrown. I know its something around security / credentials but I really don't know what exactly

  Any help will do