Adding SSDT BI Templates in Visual Studio 2015

sql-server visual-studio business-intelligence
Loki70 picture Loki70 · Dec 15, 2015 · Viewed 22.4k times · Source

I have a new laptop with Visual Studio 2015 Enterprise and SQL Server 2016 CTP 3.1 installed on it. I want to develop SSIS & SSRS projects using this setup, but I am having a hard time getting the Business Intelligence templates to show up in VS.

I installed the SQL Server Data Tools for Visual Studio 2015 from here:

https://msdn.microsoft.com/en-us/mt186501.aspx

This installation seemed to work, but the BI templates still did not appear in VS.

After this was installed, I started up the SQL 2016 installation again to see if I could add this as a feature in the installation. It was not an option in the Feature Selection area. I tried both the "Perform new installation of SQL" and "Add feature to an existing instance" options during the setup wizard.

What am I missing here? In doing some research, it seems like these BI templates should be available for VS 2015. I would greatly appreciate any suggestions. Thank you!

Answer

Moustafa Elqabbany picture Moustafa Elqabbany · Apr 15, 2017

Go to Tools > Extensions and Updates... Under the Updates tab, you'll find Microsoft SQL Server Data Tools (SSDT) Update.

Related questions

Why am I getting "Cannot Connect to Server - A network-related or instance-specific error"?

I get the following error when trying to connect to SQL Server: Cannot connect to 108.163.224.173. A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the …

Read More
How to get the connection String from a database

I have created a database with SQL Server Management Studio, I would like to now use it in my C# application. I need the connection string? Where can I find the connection string, and where is my database stored? Do …

Read More
SSIS Excel Connection Manager failed to Connect to the Source

I have a server that is capable of creating and running an Excel Import task using the Import Wizard. I am trying to automate that process by using a visual Studio 2010 Integration Services package, that I am developing on that …

Read More