Installing the (currently) latest Data Tools


August 14, 2017 by Kenneth Fisher

I’m working on a project right now and it’s going to require me not only to refresh my SSIS skills a bit but learn a few things that are only available with the latest tools. So everyone ready for a few SSIS posts? Good. Me too!

Step One and Post One!

Something that has changed over the last few years is that the install for the SQL Server Engine, SSMS (SQL Server Management Studio for writing queries and stuff) and SSDT (SQL Server Data Tools for building SSIS packages and stuff) have all become separate. The latest versions of SSMS and SSDT are v17 and are free to download, as is the SQL Server Developer edition.

So for the purposes of this post, I’m going to download SSDT.

Once the download is done (it’s small) run it.

I’m unchecking the Analysis Services tools, and while I have no intention of work with Reporting Services I don’t have an option there. You uncheck SSRS it unchecks SSDT, you uncheck SSDT and it unchecks SSRS. Basically, they are the same thing. Hit next, go through the normal legal acceptance page, and we get to the install page.

And now we wait (I’m going to bed, but my guess is it will be done by the time I get back tomorrow afternoon).

Ok, I’m back. The install appeared to go pretty quickly in the few minutes I watched it before going to bed. Either way, it installed!

The install is asking that you restart your machine so go ahead and do that now.

Once you’ve rebooted (or if you decide to skip it) go ahead and try to run SSDT for 2015.

Here you can sign into your Microsoft account and associate it with Visual Studio.

And finally, we are in!

In case you are interested SSDT is basically a set of modules for Visual Studio. If you have Visual Studio installed then the modules are added. If you don’t have it installed then a minimal “Integrated Shell” version of Visual Studio 2015 will be installed.

5 thoughts on “Installing the (currently) latest Data Tools

  1. Ilay says:

    Hi Kenneth,
    Does it work with high DPI displays ?


  2. I don’t see why it wouldn’t but honestly I have no idea. If you try it out let me know! 🙂

    • Ilay says:

      I have installed the latest one. I have the problem with the Properties window as they are not aligned properly for some reason.

      • Generally you can move the properties window around. You can attach it to one side or the other (or bottom or top) or it can be lose. You might try moving it around and see what happens.

  3. Ilay says:

    I will try to attach the screen shots here if possible.

Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

This site uses Akismet to reduce spam. Learn how your comment data is processed.

Enter your email address to follow this blog and receive notifications of new posts by email.

Join 3,755 other subscribers

Follow me on Twitter

ToadWorld Pro of the Month November 2013
%d bloggers like this: