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.
It may be a permission issue. If you can, change the Agent service account to a Windows AD account with local admin privileges.
User contributions licensed under CC BY-SA 3.0