Share via

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.
5,449 questions
SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,702 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.
371 questions
0 comments
Accepted answer
  1. ZoeHui-MSFT 41,486 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

1 additional answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Paul D 0 Reputation points
    2025-05-07T17:25:03.2466667+00:00

    Respectfully, Zoe's answer is INCORRECT.

    With your SSIS Package open in Visual Studio 2022:

    1. Open the Solutions Explorer window
    2. Right-click the Project (likely, the top-most entry in the explorer list)
    3. Select "Properties"
    4. Select "Configuration Properties"
    5. Select "General"
    6. Select "Deployment Target Version"
    7. Select "SQL Server 2016"

    Now, when you deploy the SSIS Package, the system will ensure that all embedded syntax and related are in compliance with the selected OS level.

    0 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.