When SSIS job is set on schedule through SQL Server Agent and executed it fails.

Question

I created a package and deployed it to Integration Services Catalogs. When I execute the package manually, it runs with no issues. However, I created a new schedule to run automatically and when it kicks off, it fails right away. I can't figure out the issue. Can someone please help with this? I'm attaching the report generated from the failure.

Thank you,

Marcin Gostomski

Answer 1

Hi @Gostomski, Marcin,

Is there any error message for us to do analysis?

If the package runs well manually but only fail when run it via the agent job, please follow the article to do troubleshooting.

SSIS package does not run when called from a SQL Server Agent job step

Regards，

Zoe Hui

---

If the answer is helpful, please click "Accept Answer" and upvote it.

Answer 2

I tried the solution you provided and still getting the error. I'm attaching the error log. Perhaps someone has an idea.

Thank you!

SQL Server Agent Report.pdf