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

SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,704 questions
Developer technologies | Visual Studio | Testing
Developer technologies | Visual Studio | Other
0 comments
Accepted answer
  1. ZoeHui-MSFT 41,491 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.