Can't find Targetserverversion as Sql server 2016 in VS 2022

Sarojkumar 20 Reputation points
2023-04-07T11:24:07.33+00:00

Hi, I have SQL 2016 and VS2022, recently upgraded visual studio to VS2022 and trying to edit the package compatible with version 2016. But, I can't find the targetserverversion as SQL 2016, only I can see SQL 2017, 2019, 2022. Please suggest the solution. User's image

Visual Studio
Visual Studio
A family of Microsoft suites of integrated development tools for building applications for Windows, the web and mobile devices.
4,697 questions
SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,467 questions
Visual Studio Testing
Visual Studio Testing
Visual Studio: A family of Microsoft suites of integrated development tools for building applications for Windows, the web and mobile devices.Testing: The act or process of applying tests as a means of analysis or diagnosis.
331 questions
0 comments No comments
{count} votes

Accepted answer
  1. ZoeHui-MSFT 33,551 Reputation points
    2023-04-10T01:41:38.87+00:00

    Hi @Sarojkumar,

    VS2022 till now only support target SQL Server2017-2022.

    In addition, SSIS2022 do not have a GA version now.

    I'd like to suggest that you may wait for the GA version or use VS2019 temporarily.

    Regards,

    Zoe Hui


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

    1 person found this answer helpful.
    0 comments No comments

0 additional answers

Sort by: Most helpful