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
Developer technologies | Visual Studio | Testing
Developer technologies | Visual Studio | Other
Developer technologies | Visual Studio | Other
A family of Microsoft suites of integrated development tools for building applications for Windows, the web, mobile devices and many other platforms. Miscellaneous topics that do not fit into specific categories.
0 comments
Answer accepted by question author
  1. ZoeHui-MSFT 41,506 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' by the question author and 'Recommended' by moderators, which helps users know the answer solved the author's problem.