CODEWITHSUNDEEP
ssisssassql-server-2014sql-server-data-tools
user5947731
user5947731

Reputation: 57

SQl server data tools (SSDT - BI) for SQL Server 2014

We are upgrading from SQL Server 2008 R2 to SQL Server 2014 and I tried to install SQL server data tools for 2014 for SSIS, SSAS. From all the forums I read online, I installed Visual studio 2013 on my machine first and then I added SSDT 2014 for Visual studio 2013.

Is this the right way to do SSDT-BI 2014 Installation?

Upvotes: 1

Views: 5785

Answers (2)

Bhanu
Bhanu

Reputation: 1121

If you want to install only SSDT-BI for SQLServer2014, without requiring VS2013 license, then follow the below steps to setup development environment for SSIS, SSRS and SSAS.

  1. Install Microsoft Visual Studio 2013 Shell (Isolated) Redistributable Package
  2. Install Microsoft Visual Studio 2013 Shell (Integrated) Redistributable Package
  3. Install Microsoft SQL Server Data Tools - Business Intelligence for Visual Studio 2013

Upvotes: 0

mramirez
mramirez

Reputation: 11

SSDT for Visual Studio 2013 has 2 versions: The one that has only DB tooling and other with BI components. You need to look for "SSDT-BI" Here you go:

Microsoft download link for SSDT-BI

For VS 2015 and SQL Server 2016, the current version of SSDT comes with both SQL Server tooling AND BI components, so it's one download.

Hope this helps!

Upvotes: 1

Related Questions