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


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

SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,496 questions
0 comments No comments
{count} votes

2 answers

Sort by: Most helpful
  1. ZoeHui-MSFT 34,591 Reputation points

    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


    Zoe Hui

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

    0 comments No comments

  2. Anonymous

    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

    0 comments No comments