Microsoft released an update to SQL Server Data Tools (SSDT) 2016 on 20 Sep 2016 – the tool used to design databases, SSIS, SSRS, and SSAS solutions.
I can hear you thinking, “How do I get the update, Andy?” You can get version 14.0.60918.0 here.
If you have the installer for SQL Server 2016 handy, you can get to the download link very easily. Start the installer and click the Installation page:
There’s a link labeled “Install SQL Server Data Tools.” Click that link to go to the Download SQL Server Data Tools (SSDT) page. To get the Visual Studio 2015 version of SSDT 2016, click that top button / link:
The button / link will take you to the Visual Studio-specific download page for SSDT:
There’s a link under #3 (at the time of this writing) for downloading the web installer:
Your mileage may vary, but I had trouble getting the web installer to work for the 20 Sep 2016 update. So I scrolled down a little and grabbed the ISO link under #4 (at the time of this writing):
You can mount the ISO file using Windows Explorer:
Once mounted the ISO file acts like an optical drive:
From here, you can execute the SSDTSETUP.EXE file and install the update.
:{>
Related Training:
IESSIS1: Immersion Event on Learning SQL Server Integration Services – April 2017, Chicago
IESSIS2: Immersion Event on Advanced Integration Services – May 2017, Chicago
Learn More:
Biml Academy
The Basics of Biml – the Execute SQL Task
The Basics of Biml – Populating the Biml Relational Hierarchy
Stairway to Biml
Stairway to Integration Services
Varigence.com
BimlScript.com
SQL Server Central
Need help or training implementing a Biml solution?
Contact Enterprise Data & Analytics today!
Hi Andy, thanks for blogging about this. A couple of quick notes that may help people:
– You may notice the new “Download SQL Server Data Tools” link at the top of the download page. We added this for this release, and means you no longer have to search for the SSDTSetup.exe link for your language in the Administrative install section. Hopefully this will simplify things for people
– We have updated the link in Visual Studio Extensions and Updates to the latest version. This is a good place to check and we’re working to get the version listed updated more quickly in the future.
– Typing “SSDT Download” into your search engine of choice will get you to the download page.
Thanks,
Kevin Cunnane,
SQL Server tools team