Title: Visual Studio and SQL Business Intelligence:

Author: Toraj Khavari

Date: Jan 24, 2018

Objective: Setup Visual Studio 2017, 2015, 2013, 2012 and 2010 to include SQL Business Intelligence projects.

Article Body: Visual Studio and SQL Business Intelligence are two powerful technologies. Together, in an integrated development environment, are a software engineer’s dream come true. It took me a bit to figure out how to add SQL Business Intelligence projects to the Visual Studio (I use). The following discusses what has worked for me.

Visual Studio 2017 – VS2017

The SQL Business Intelligence for VS2017 is available. 

https://docs.microsoft.com/en-us/sql/ssdt/download-sql-server-data-tools-ssdt

Visual Studio 2015 – VS2015

The SQL Business Intelligence for VS2015 is available. 

https://msdn.microsoft.com/en-us/library/mt204009.aspx

Visual Studio 2013 – VS2013

Installed “Microsoft SQL Server Data Tools - Business Intelligence for Visual Studio 2013”

http://www.microsoft.com/en-us/download/confirmation.aspx?id=44213

Visual Studio 2012 – VS2012

Installed “Microsoft SQL Server Data Tools - Business Intelligence for Visual Studio 2012”

http://www.microsoft.com/en-us/download/confirmation.aspx?id=36843

Visual Studio 2010 – VS2010

This gets a bit interesting. In my case, I was interested in the SQL 2012. Locate the install package for SQL 2012. Install the “SQL Server Data Tools.” It was in the “SW_DVD9_SQL_Svr_Standard_Edtn_2012_English_MLF_X17-97001.ISO” file.

In all the above cases, you can test a successful install by opening a new Business Intelligence project in Visual Studio. File > New > Project.

Have fun using Visual Studio and SQL. The SQL Business Intelligence projects are powerful.

Cheers, Toraj

References:

-          http://blog.nwcadence.com/sql-server-data-tools-clearing-up-the-confusion
      Added VS2015 - 7/18/2016