SSIS package will not run from SQL Agent Job

Foster Holt 1 Reputation point
2022-07-05T19:30:18.473+00:00

I am migrating from SQL Server 2016 in our data center to a SQL Server 2022 on a VM in Azure. I have many SSIS tasks I need to migrate. Most of the SSIS tasks call C# exe (via Process Task) located on the SQL Server instance. The SSIS packages are deployed to SQL Server. When I run the SSIS package manually, it works fine. When I run the SSIS package from a SQL Agent Job it fails. Thinking it was a permission issue, I switched the default user for SQL Agent service to my userid to see if SQL Agent job would run...but no luck.

The error message doesn't tell me anything and I was wondering if anyone had any idea what might be wrong or possibly additional things I could do to better diagnose what the issue might be.

217769-image.png

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

1 answer

Sort by: Most helpful
  1. ZoeHui-MSFT 40,586 Reputation points
    2022-07-06T02:19:41.307+00:00

    Hi @Foster Holt ,

    As far as I known, VS2019 could not set the target to SQL Server 2022.

    VS 2022 support is one major item that SSIS team is working on, current outlook is before end of this year.

    So I think that you could not use SQL Agent Job to run package in SQL Server2022.

    Details you may refer to SQL Server Integration Services Projects Q&A

    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.


Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.