Cannot install SSIS, no Visual Instance Studio found

Krista Moore 35 Reputation points
2023-07-26T22:35:33.9+00:00

I have Visual Studio 2022, Visual Studio 2017, SSMS 19 installed on my machine, but when I go to install SSIS no instance of VS is found.

SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,592 questions
0 comments No comments
{count} vote

5 answers

Sort by: Most helpful
  1. ZoeHui-MSFT 37,671 Reputation points
    2023-07-27T01:58:55.56+00:00

    Hi @Krista Moore,

    Click on "Extensions" > "Manage Extensions" in your Visual Studio.

    In the search bar of the opened window, we type "Integration Services" to easily locate the extension. From the appeared list we choose "SQL Server Integration Services Projects" and press "Download".

    Here is a detail tutorial, you may take a reference to.

    Regards,

    Zoe Hui


    If the answer is helpful, please click "Accept Answer" and upvote it.

    3 people found this answer helpful.

  2. Bruce (SqlWork.com) 66,706 Reputation points
    2023-07-27T00:37:53.71+00:00

    SSIS is tied to the Sqlserver version. What version are you installing? The install is part of the Sqlserver installer.

    The SSIS data tools for vs install depends on the the version of vs. only vs2022 and vs2019 have a data tools package. Older versions of the data tools install the matching vs version as part of the install. See

    https://learn.microsoft.com/en-us/sql/ssdt/download-sql-server-data-tools-ssdt?view=sql-server-ver16

    0 comments No comments

  3. Olaf Helper 45,106 Reputation points
    2023-07-27T05:43:28.4933333+00:00

    but when I go to install SSIS no instance of VS is found.

    You post is a bit unclear/confusing; what excatly & full error message do you get when you do what? Please describe it more detailed.


  4. Krista Moore 35 Reputation points
    2024-04-23T22:54:31.2766667+00:00

    The SSIS 2022 install we downloaded from the marketplace page was not the current version. My coworker did a search from extension manager and was able to get a link to the newer version by luck. The file version 16.0.5228.0 is the install that finally worked for us

    0 comments No comments

  5. Krista Moore 35 Reputation points
    2024-04-23T22:58:31.9633333+00:00

    The SSIS 2022 install we downloaded from the marketplace page was not the current version. My coworker did a search from extension manager and was able to get a link to the newer version by luck. The file version 16.0.5228.0 is the install that finally worked.

    0 comments No 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.