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

Anonymous
2023-05-03T14:51:21.4233333+00:00

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
    2023-05-04T02:40:21.25+00:00

    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.

    0 comments No comments

  2. Anonymous
    2023-05-05T21:49:19.5433333+00:00

    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