question

skkeni04 avatar image
skkeni04 asked

Error in job agent when executing a package in SSISDB catalog

I created a simple package in Visual Studio. Then I deployed this package in SSISDB catalog which is on a different server. I am using a Job agent to execute this package with a proxy account. But I am getting this error in Job Agent:

"Executed as user: ***\test. Microsoft (R) SQL Server Execute Package Utility Version 13.0.5153.0 for 64-bit Copyright 2016 Microsoft. All rights reserved. Failed to execute IS server package because of error 0x80131904. Server: ****, Package path: ****.dtsx, Environment reference Id: NULL. Description: Login failed for user: ***\test. Source: .Net SqlClient Data Provider. .... The package execution failed. The step failed."

Let me know if any more info is needed. Kindly help me with identifying this issue.

ssissql serversql-server-2016sql-server-agent
10 |1200 characters needed characters left characters exceeded

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

0 Answers

· Write an Answer

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.