SQL Server Agent Job fails to execute ETL package

Question

Hi, i scheduled an ETL job to update my data warehouse (using SQL SERVER AGENT). the job is running for seconds and giving following error

SSIS Error Code DTS_E_OLEDBERRO. An OLE DB error has occurred. Error code: 0x80040E4D
An OLE DB record is available. Source "Microsoft SQL Server Native Client 11.0" Hresult 0x80040E4D. Description: "Login failed for user 'XX\XXX$'.".

My Version is : SQL Server 2016

when i run the job manually its working fine. Can anyone help with a suggestion?

Answer 1

Hi @Mohammed Abdul Majeed Khan ,

Description: "Login failed for user 'XX\XXX$'."

From the error message, it indicates that the user account does not have the required permissions to make connections or to access resources outside the SSIS package.

Create a proxy account for the user who have enough permission on underlying database and run the job step with that proxy.

Check this link for details.

run-an-ssis-package-under-a-different-account

Regards，

Zoe

---

If the answer is the right solution, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".

Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.