Share via

SSIS Update unsupported

Smith, Carl 20 Reputation points
2023-09-20T15:31:45.4033333+00:00

Hello! I am new to SSIS. I just recently updated my visual studio installer to the Visual Studio Community 2019 16.11.30.

Once I updated this, I can no longer access my previous ssis packages. Attached I have a picture of the error of I am receiving.

User's image

Visual Studio
Visual Studio
A family of Microsoft suites of integrated development tools for building applications for Windows, the web and mobile devices.
4,767 questions
SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
13,070 questions
SQL Server Migration Assistant
SQL Server Migration Assistant
A Microsoft tool designed to automate database migration to SQL Server from Access, DB2, MySQL, Oracle, and SAP ASE.
503 questions
Visual Studio Debugging
Visual Studio Debugging
Visual Studio: A family of Microsoft suites of integrated development tools for building applications for Windows, the web and mobile devices.Debugging: The act or process of detecting, locating, and correcting logical or syntactical errors in a program or malfunctions in hardware. In hardware contexts, the term troubleshoot is the term more frequently used, especially if the problem is major.
958 questions
Visual Studio Setup
Visual Studio Setup
Visual Studio: A family of Microsoft suites of integrated development tools for building applications for Windows, the web and mobile devices.Setup: The procedures involved in preparing a software program or application to operate within a computer or mobile device.
989 questions
0 comments
Accepted answer
  1. Yitzhak Khabinsky 25,381 Reputation points
    2023-09-20T18:25:07.6433333+00:00

    @Smith, Carl,

    What is the version of the "SQL Server Integration Services Projects" extension for VS2019 that you are using?

    Please try to install the latest version of it from here: https://marketplace.visualstudio.com/items?itemName=SSIS.SqlServerIntegrationServicesProjects

    1 person found this answer helpful.
    0 comments

2 additional answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Olaf Helper 42,386 Reputation points
    2023-09-21T05:29:35.9733333+00:00

    The project types may not be installed...

    As the message says, SSIS is not a standard project type, you have to install it.

    0 comments
  2. Anna Xiu-MSFT 27,256 Reputation points Microsoft Vendor
    2023-10-02T09:49:49.1633333+00:00

    Hi @Smith, Carl, 

    Welcome to Microsoft Q&A! 

    You can install the “SQL Server Integration Services Projects” extension within Visual Studio:

    click on Extensions menu > Manage Extensions > search “SQL Server Integration Services Projects” > select Download. 

    Then, the extension will be installed after all VS instances are closed.

    After the SSIS extension is installed, you can re-open your SSIS project.

    Sincerely,

    Anna

    If the answer is the right solution, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment". 
    Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

    0 comments