Visual Studio 2017 Community Edition SSIS

Ven Ataci 1 Reputation point
2022-02-06T12:12:46.237+00:00

Hello I am running Windows 10 Pro 64bit. I have Visual Studio 2017 Community Edition installed, and SQL Server 2019 Developer Edition, both installed fine. However, when I try to install Sql Server Integration Services on Visual Studio, using the Microsoft.DataTools.IntegrationServices tool. When running the Tool, I get a Menu prompt, requesting to choose the instance of Visual Studio, but there is nothing listed/no version of Visual Studio listed to choose from, and not other option to continue. Any ideas on what could be the issue? Or is there another Method to install SQL Server Integration Services on the version of Visual Studio? I was able to install SQL Server Database projects to Visual Studio, I just cannot figure out how to do this for SSIS. Thanks for any assistance.

Developer technologies | Visual Studio | Other
0 comments No comments
{count} votes

1 answer

Sort by: Most helpful
  1. Ven Ataci 1 Reputation point
    2022-02-06T16:30:19.13+00:00

    I got this fixed. I had to download and run SSDT for VS 2017 (standalone installer) SSDT-Seup-EXE, instead of Microsoft.DataTools.IntegrationServices.exe
    The process of adding SSIS looked the same with running both tools, but the SSDT-Seup-EXE tool is what I needed to get this working.
    It has been so many years since it did an installation, setup like this I couldn't remember.


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.