Information, tips, news and announcements about SQL Server Analysis Services and PowerPivot directly from the product team.
Yesterday we released SQL Server Data Tools – Business Intelligence for Visual Studio 2013 (SSDT BI) for SQL Server 2014. With this release you can use SSDT BI in Visual Studio 2013 and it includes the Visual Studio Project Templates for Analysis Services, Integration Services, and Reporting Services. The project templates in this release generally work with down level versions of the server (with the exception of SSIS). See the image below for details.
We have also retired the CTP version that was based on VS 2012.
SSDT-BI for Visual Studio 2013 has been re-released in English. It can be downloaded from: http://www.microsoft.com/en-us/download/details.aspx?id=42313.
It works on SQL Server 2008 Reporting Services?
@Kasper de Jonge:
Will support for SSIS 2012 also developed?
- We have a huge problem - customer has SSIS (MSSQL) 2012
- Development in VS 2012 (SSDT BI 2012) is simply unpossible - look at many Bug reports on connect Web Site for SSDT BI 2012
- SSDT BI 2014 is for VS 2013 but has no support for SSIS 2012. In any case not for custom components.
What shall we do? How can we work? Is it a pressure from Microsoft to migrate to MSSQL 2014?
Any idea when this will be re-released? Trying to get a SQL 2014 demo database up. Loading sample data in using the "import data" wizard or sql bulk loading is frustrating, to say the least.
When will this be working again? Killed migration to VS2013 dead in its tracks.
Any ETA on when it will be available again? Finally started migrating to VS2013 and now dead in the water again...
It has been more than a week now... do we know when this tool will be available again?
If this product was managed like Azure or Office, it would be fixed by now.
Does anyone know if the CTP2 version of SSDT-BI will work with the full release of SQL 2014? We're taking considerable heat for not being able to make the switch to 2014/VS 2013 by this weekend. We'll take anything to get us moving, even if it's a bit glitchy.
@Eric We've identified a fix to the issue and expect the update out soon. I hesitate to give out dates since there might be a slip. But, we're talking about a week at this point.
Agreed. VS 2013 for BI is a real pain. We are in SQL 2012 (BI) and not moving anytime soon: Not enough added value for Corporate BI in SQL 2014. (As stated by some other post, there is absolutely NOTHING new in SSIS, SSRS or SSAS)
An update. Which I'll try and get posted to the blog generally.
We are working very hard on this but we're not done yet. We know this is a problem for many of our customers and we're sorry for the delay. We also want to make sure we keep you up to date on where we're at so it's not a big mystery. The problem is with some code we share with other products (e.g., SMO.) So, the installation of SSDT-BI affects other products such as SSDT-DB. Getting things to work completely right with several other big products can be tricky and can take a while to fix and then test. We hoped to have the update ready by today but hit a snag in our approach to fix it. So, it will take at least a couple of weeks. This is the number one priority for quite a few people right now.
Couple of weeks is really a long time for such as issue that can be avoided in the first place. SSDT-BI has always been issues people complained about for the last 2-3 versions due to bad coordination between VS Team and SQL Team.
@Iced Tea - entirely agreed. And what's worse is they only selectively publish comments on these blogs, so you're likely only seeing half of the complaints.
This is all happening at a point in time when my own organization is reconsidering our business intelligence strategy from the ground up. I'd like it to include SSAS, SSIS, and SSRS - but MS has been making it a very hard sell.
Can we get an ETA on the support of SSDT as listed above and the 2012 SSIS component?
Does the VS 2012 SSDT-BI package released in February work with SQL Server 2014? While it would be nice to have VS 2013 package I just need something that works with SQL Server 2014 to do some cube design right now.
Wonder when they will get the Report Viewer to print in Chrome and drop ActiveX? The Report Builder 3 for Sql Server 2014 won't install either.