CODEWITHSUNDEEP
ssisprojectvisual-studio-2019
High Plains Grifter
High Plains Grifter

Reputation: 1571

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

Upvotes: 7

Views: 26927

Answers (2)

Mark Wojciechowicz
Mark Wojciechowicz

Reputation: 4477

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

Upvotes: 6

J Weezy
J Weezy

Reputation: 3957

I don't think you will find it by searching for Integration, did you try SSIS? Microsoft has a steps process here: https://learn.microsoft.com/en-us/sql/integration-services/lesson-1-1-creating-a-new-integration-services-project?view=sql-server-ver15

Upvotes: 1

Related Questions