SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 

Installing the (currently) latest Data Tools

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.


Filed under: Microsoft SQL Server, SQLServerPedia Syndication, SSIS Tagged: microsoft sql server, SSIS

SQLStudies

My name is Kenneth Fisher and I am Senior DBA for a large (multi-national) insurance company. I have been working with databases for over 20 years starting with Clarion and Foxpro. I’ve been working with SQL Server for 12 years but have only really started “studying” the subject for the last 3. I don’t have any real "specialities" but I enjoy trouble shooting and teaching. Thus far I’ve earned by MCITP Database Administrator 2008, MCTS Database Administrator 2005, and MCTS Database Developer 2008. I’m currently studying for my MCITP Database Developer 2008 and should start in on the 2012 exams next year. My blog is at www.sqlstudies.com.

Comments

Leave a comment on the original post [sqlstudies.com, opens in a new window]

Loading comments...