The Microsoft SQL Server product team finally released the long awaited SQL Server Data tools – BI templates for Visual Studio 2012. This release installs the SQL Server Business Intelligence projects for Analysis Services, Integration Services, and Reporting Services. Among other things, the release also enables you to create and edit SQL Server 2008 R2 or SQL Server 2012 SSRS reports. You can download and install the tools from here: http://www.microsoft.com/en-us/download/details.aspx?id=36843
Installing the tools however had the adverse effect of causing the data projects in our Visual Studio solutions to fail from working. Here’s what you will need to do to resolve the issue if your database projects are failing to load as well:
- Download and install the SSDT December 2012 Update from here: http://go.microsoft.com/fwlink/?LinkID=274984
- Download and install the Data-Tier Application framework from here: http://www.microsoft.com/en-us/download/details.aspx?id=36842.
If you are on an x64 machine, make sure you install the x86 updates (first) as
well the x64 updates listed in this URL.
Your database projects should work fine after installing the above updates. One last thing worth mentioning is that I currently am on Visual Studio 2012 Update 1 and also that the December 2012 update is the latest one available at this time.