(update 2014/11/14: added link to the VS 2013 release which came out in April)
Looking for the SSIS development tools? Formerly known as Business Intelligence Developer Studio (BIDS), the designer is now called SQL Server Data Tools – Business Intelligence (SSDT-BI) (not to be confused with the other SQL Server Data Tools). The version you want will depend on two things; your version of SQL Server, and the version of Visual Studio you want to work with.
SQL Server 2012
- The SQL installation media includes the tools for Visual Studio 2010
- You can download SSDT-BI 2012 for Visual Studio 2012 from the Microsoft download center
SQL Server 2014
- Download SSDT-BI 2014 CTP2 for Visual Studio 2012 from the Microsoft download center
- SSDT-BI 2014 for Visual Studio 2013
Availability data and drug discounts are stored in a database and you can quickly find out how many pills you have at your disposal.
Some notes:
- The SQL Server 2014 CTP2 version of SSDT-BI should not be installed on the same machine as SSDT-BI for SQL Server 2012
- There is no SQL Server 2014 SSDT-BI for Visual Studio 2010, however, SSIS packages developed in SQL Server 2012 can be automatically upgraded to SQL Server 2014
Do you know when the SSDT-BI for VS2013 will be available?
Probably when VS2017 is out.
Annoying, isn't it?
It will be much sooner than that 🙂
Or more specifically when will SQL Server *2012* SSDT-BI for Visual Studio 2013 be available.
No release dates have been announced. More details can be found on the SQL Server team blog – http://blogs.technet.com/b/dataplatforminsider/ar…
So, if our folks are still contending with SSRS development on SQL Server 2008 R2 (yes, I know… old), should they continue using VS2008 BI tools, or can they move on to SSDT-BI for VS2012?
Looks like it was released: http://www.microsoft.com/en-us/download/details.a…
I downloaded two days ago, but as of today, it redirects to a text file containing a message;
"SSDT-BI has been temporarily removed to deal with side by side issues with SSDT-SQL. We expect to have it reposted soon"
It seems that the latest SSDT refresh broke the Script Task (editing and perhaps debugging, too). Must be applicable to having SSDT 2012 / VS 2012 and/or SSDT 2010 and 2012 alongside.
Re-applying SSDT 2010 from http://go.microsoft.com/fwlink/?LinkID=241405 seems to help resolving this issue.
PS: There are many SSIS MSDN forum postings about that.
On April 17th Lance Delano, Group Program Manager at Microsoft, said they're trying to re-release these tools in about a week if there are no hiccups: http://blogs.msdn.com/b/analysisservices/archive/…. But no promises.
Matt hello,
in light of the Visual Studio 2013 BI release for SSIS 2014 please update the blog post with the relevant link (provided by S. Rasmussen).
Thank you!