locked
How to install SSDT? RRS feed

  • Question

  • Hello!  I have been struggling lately with how to get SSDT installed and I am totally confused. Presently I am running Windows 7 Pro (64 bit), SQL Server 2014 and Visual Studio 2015 (both free versions).

    I downloaded and installed SSDT - BI for VS 2013 (https://www.microsoft.com/en-us/download/details.aspx?id=42313), yet when I opened VS 2015 there was no option to create an Integration Services package, etc.  In looking further, it appeared perhaps SSDT was ONLY compatible with VS 2013, so I downloaded and installed VS 2013 (free version) as well from here: https://www.microsoft.com/en-us/download/details.aspx?id=44914   After rebooting my machine and going through the initial startup of VS 2013, I went to create a new project and again there was no option for Integration services, etc.

    Some people have said that SSDT comes prepackaged with VS 2013 and I should check in the Tools --> Updates and Extensions menu, however when I went there and searched for "SQL Server", there was no extension for SSDT.  I also checked the Tools --> Updates and Extensions in VS 2015 and again found nothing for SSDT.

    What am I missing here??  Any help would be MOST appreciated!!

    Friday, April 15, 2016 12:12 PM

Answers

  • Hi Isaac,

    Firstly, apologies for the confusion.  The SSDT/SSDT-BI story is more confusing than it should be and we're working to make it simpler. Here's what you need to know:

    - For Visual Studio 2013, there are two different products that are called "SSDT".  One SSDT includes tools for relational databases in Visual Studio, with features like Data Compare, Schema Compare and SQL Server Database Projects. The other SSDT, referred to as SSDT-BI, includes the BI project types for SSRS, SSIS and SSAS. The SSDT relational tools are included in Visual Studio's setup experience as a checkbox option, but the SSDT-BI tools, on the other hand, are only available as a separate download. This "two SSDTs" thing caused a lot of confusion and was widely regarded as a bad move, so for Visual Studio 2015 we've made some changes.

    - For Visual Studio 2015, the relational and BI tools are now available via a single installer.  The tools are currently in Preview, because they're aligned with the release of SQL Server 2016.  You can get the SSDT Preview for Visual Studio 2015 here: https://msdn.microsoft.com/en-us/mt429383

    - Even though the SSDT tools for Visual Studio 2015 linked above are Preview, they are supported and we ship updates (for the most part) monthly.  The GA version of these tools will be a seamless upgrade from the Preview version.

    Thanks!

    Friday, April 15, 2016 5:18 PM

All replies

  • Hi,

    Please have a look at this, maybe it can help you.

    https://msdn.microsoft.com/en-us/mt186501.aspx?f=255&MSPPError=-2147217396


    Please mark this reply as answer if it solved your issue or vote as helpful if it helped so that other forum members can benefit from it

    Friday, April 15, 2016 12:33 PM
  • You need to download the "Preview" version of SSDT for VS 2015 in order to create and edit SSIS packages in VS 2015.

    Please see:

    https://msdn.microsoft.com/en-us/library/mt204009.aspx?f=255&MSPPError=-2147217396

    Friday, April 15, 2016 12:45 PM
  • Hi Isaac,

    Firstly, apologies for the confusion.  The SSDT/SSDT-BI story is more confusing than it should be and we're working to make it simpler. Here's what you need to know:

    - For Visual Studio 2013, there are two different products that are called "SSDT".  One SSDT includes tools for relational databases in Visual Studio, with features like Data Compare, Schema Compare and SQL Server Database Projects. The other SSDT, referred to as SSDT-BI, includes the BI project types for SSRS, SSIS and SSAS. The SSDT relational tools are included in Visual Studio's setup experience as a checkbox option, but the SSDT-BI tools, on the other hand, are only available as a separate download. This "two SSDTs" thing caused a lot of confusion and was widely regarded as a bad move, so for Visual Studio 2015 we've made some changes.

    - For Visual Studio 2015, the relational and BI tools are now available via a single installer.  The tools are currently in Preview, because they're aligned with the release of SQL Server 2016.  You can get the SSDT Preview for Visual Studio 2015 here: https://msdn.microsoft.com/en-us/mt429383

    - Even though the SSDT tools for Visual Studio 2015 linked above are Preview, they are supported and we ship updates (for the most part) monthly.  The GA version of these tools will be a seamless upgrade from the Preview version.

    Thanks!

    Friday, April 15, 2016 5:18 PM
  • Thank you so much, Steven!  I now have the correct package installed and I am on my way to designing my first SSIS project.  

    I agree the two-tools-same-name issue is wickedly confusing and I look forward to however this gets clarified in the future.

    Thanks so much for your detailed reply. 

    Saturday, April 16, 2016 7:46 PM