Share via

2016 version is missing from target server version in ssis project propeties

Nishan Ratna 150 Reputation points
2023-05-02T12:25:36.4766667+00:00

I am using Visual studio 2022 for creating SSIS packages. Now I want to deploy my ssis package to a sql server 2016 version. However, I am not able to select it from the list. what can i do? can someone please help me?

User's image

Thanks

SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,702 questions
0 comments
Accepted answer
  1. Yitzhak Khabinsky 26,586 Reputation points
    2023-05-02T12:56:13.9866667+00:00

    Hi @Nishan Ratna,

    The SQL Server Integration Services Projects extension for VS2022 is a preview version with many bugs and limitations. You bumped into one of them.

    You need to use Visual Studio 2019 and its SQL Server Integration Services Projects extension to develop SSIS projects targeting 2016 version. It supports the following SSIS run-time versions: 2012, 2014, 2016, 2017, 2017, 2019, 2022.

    https://marketplace.visualstudio.com/items?itemName=SSIS.SqlServerIntegrationServicesProjects

    2 people found this answer helpful.
    0 comments

0 additional answers

Sort by: Most helpful
Most helpful Newest Oldest

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.