which version of Visual Studio Azure SSIS IR supports to design and execute SSIS Package

Parihar, Rishi S 0 Reputation points
2025-02-27T14:53:08.68+00:00

which version of Visual Studio Azure SSIS IR supports to design and execute SSIS Package?

We are using Visual Studio Community version 2019 to design SSIS package and will use Azure SSIS IR to run and facing with Script task compilation error in ADF. Could you please suggest solution?

Can we use VS Community 2022 and run top of ADF using selfhosted SSIS IR?

Visual Studio Setup
Visual Studio Setup
Visual Studio: A family of Microsoft suites of integrated development tools for building applications for Windows, the web and mobile devices.Setup: The procedures involved in preparing a software program or application to operate within a computer or mobile device.
1,101 questions
0 comments No comments
{count} votes

1 answer

Sort by: Most helpful
  1. Anna Xiu-MSFT 30,921 Reputation points Microsoft Vendor
    2025-02-28T03:29:23.86+00:00

    Hi @Parihar, Rishi S, 

    Welcome to Microsoft Q&A! 

    You can use the Visual Studio Community 2022 with SQL Server Data Tools (SSDT) installed to design SSIS package.

    Then, deploy and run packages in Azure. 

    For more information, please visit Deploy and run packages in Azure

    If you are facing script task compilation error in ADF, please start a new question so that we can better solve your problem. Thanks for your understanding. 

    Sincerely,

    Anna


    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.

    0 comments No comments

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.