Jobs failed with the following errors

0

this is the first time I've tried to schedule a job and I keep getting the error message below. I am using the admin account and checking the 32 bit box. Any ideas on how to remedy? Thanks.

Executed as user: NT Service\SQLAgent$BZMSSQLSERVER. Microsoft (R) SQL Server Execute Package Utility Version 14.0.2014.14 for 32-bit Copyright (C) 2017 Microsoft. All rights reserved.

Started: 9:48:28 AM Error: 2019-12-02 09:48:29.50

Code: 0xC0202009

Source: TEST Connection manager "DestinationConnectionExcel"

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: "The Microsoft Jet database engine cannot open the file ''. It is already opened exclusively by another user or you need permission to view its data.". End Error

Error: 2019-12-02 09:48:29.50

Code: 0xC00291EC

Source: Preparation SQL Task 1 Execute SQL Task

Description: Failed to acquire connection "DestinationConnectionExcel". Connection may not be configured correctly or you may not have the right permissions on this connection. End Error

DTExec: The package execution returned DTSER_FAILURE (1).

Started: 9:48:28 AM

Finished: 9:48:29 AM Elapsed: 0.641 seconds. The package execution failed. The step failed.

sql-server
asked on Stack Overflow Dec 2, 2019 by Sm85 • edited Dec 2, 2019 by Larnu

1 Answer

0

It may be a permission issue. If you can, change the Agent service account to a Windows AD account with local admin privileges.

answered on Stack Overflow Dec 2, 2019 by Israel H.

User contributions licensed under CC BY-SA 3.0