Aruna Raghunam
Aruna Raghunam

Reputation: 921

Visual Studio 2017 not showing SSIS

I have recently installed SSMS 2017 and Visual Studio 2017 Community edition. However, I cannot see an option to create Integration Services projects. Can you please guide me how to proceed.

Thanks, Aruna

Upvotes: 4

Views: 4666

Answers (2)

Gerhard Schmeusser
Gerhard Schmeusser

Reputation: 49

It worked for me only after I had deinstalled the older versions of Visual Studio for Applications 2014 and 2015 before I updated the ones for 2017 and 2019.

Upvotes: 0

Hadi
Hadi

Reputation: 37368

What @Nick.McDermaid mentioned is true. To eliminate any confusion, during the visual studio installation there is a feature called SQL Server Data Tools; this will not perform a full SSDT installation.

Based on this Microsoft article:

For most users, SQL Server Data Tools (SSDT) is installed during Visual Studio installation. Installing SSDT using the Visual Studio installer adds the base SSDT functionality, so you still need to run the SSDT standalone installer to get AS (Analysis Services), IS (Integration Services), and RS (Reporting Services) tools.

To download SSDT you can follow the link above.

Upvotes: 3

Related Questions