Reputation: 921
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
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
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