Installing SSDT 15.8 for visual studio 2017 failing to install

HP 21 Reputation points
2024-01-22T22:17:06.7333333+00:00

Hello, I am trying to install SSDT 15.8 for visual studio 2017 on windows 11 and keeps on failing. VS 2017 is installed with Data Storage and Processing option. I have tried uninstall/install of VS 2017, frame work 4.8 multiple times without any success. SSDT running as admin crashing as son as I select Visual Studio 2017 from dropdown without clicking Install button. Also, not able to find Integration service project template in extension and updates in VS 2017 Also tried installing with command prompt, SSDT-Setup-ENU.exe /INSTALLIS /passive. This shows up in Programs and feature but in VS studio i do not show template to create new integration service project. I have been looking for solution for a while now with any success. Any help is appreciated. Thanks

SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,414 questions
Visual Studio Extensions
Visual Studio Extensions
Visual Studio: A family of Microsoft suites of integrated development tools for building applications for Windows, the web and mobile devices.Extensions: A program or program module that adds functionality to or extends the effectiveness of a program.
160 questions
Windows 11
Windows 11
A Microsoft operating system designed for productivity, creativity, and ease of use.
7,634 questions
{count} votes

1 answer

Sort by: Most helpful
  1. Yitzhak Khabinsky 24,641 Reputation points
    2024-01-22T22:20:32.7766667+00:00

    It is better to start using VS2019. Even free of charge Community edition is good enough to develop SSIS projects. VS2019 is not using SSDT anymore. It needs "SQL Server Integration Services Projects" extension for VS2019. Here is its download link: https://marketplace.visualstudio.com/items?itemName=SSIS.SqlServerIntegrationServicesProjects

    VS2019 supports all versions between 2012 - 2022. Please see below. SSIS - TargetServerVersion_2