Search code examples
ssisprojectvisual-studio-2019

Visual Studio 2019 New Project does not include SSIS, whcih is installed


I can open, edit and deploy existing SSIS projects in Visual Studio 2019 (16.6.0), but cannot see SQL Server Integration Services or related items in the list of available templates when I add a new project. I do not know why this is, since SQL Server Integration Services Projects is installed, and I think that is all I need. I am seeking Advice on how to make SSIS appear in the list of templates.

Edit: I also searched the following terms with no luck: SSIS, SSDT, Business, SQL, Intelligence

Demonstration that SQL Server Integration Services Projects is installed:

Demonstration that SQL Server Integration Services Projects is installed

Demonstration that I cannot see the related templates in the list when adding a new project:

enter image description here


Solution

  • Please make sure that you have the latest extension installed, which can be downloaded from here:

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

    I checked and I am able to see the template searching for both integration and ssis: enter image description here