21 August 2012

Visual Studio 2012 does not support SSAS, SSIS or SSRS

Visual Studio 2012 and SQL Server 2012 have been launched by Microsoft recently.


Having that into account I was expecting to have full integration between the two products, but I discovered the hard way that Visual Studio 2012 does not have any support for the Integration Services (SSIS), Analisys Services (SSAS) or even the Reporting Services  (SSRS) projects.

The SQL Server 2012 data tools (SSDT) offer an integrated environment within Visual Studio 2010, but there is no support for Business Intelligence on Visual Studio 2012!

The SQL Server 2008 had the same issue with Visual Studio 2010.

So get ready to have Visual Studio 2012 and Visual Studio 2010 side by side on the same development machine.

2 comments:

Rohan Cragg said...

I think you may have some problem with the installation as SSDT is included with VS2012 RTW, see the announcements here:

http://social.msdn.microsoft.com/Forums/en-US/ssdt/threads

"SQL Server Data Tools in Visual Studio 2012"

Rohan Cragg said...

Actually - I think you're right:

http://www.sqlservercentral.com/blogs/jamesserra/2012/07/25/visual-studio-2012-does-not-support-bi/