Visual Studio 2012 + Business Intelligence Templates

Question

I got SQL Server 2012 installed on my machine and I have SSDT to create BI projects.

Today i installed Visual Studio 2012; but i cannot create any of BI projects in Visual Studio 2012. Is there a way I can open BI (SSIS/SSAS/SSRS) projects in VS 2012 or should i have to always go back to SSDT to open them.

Answer 1

SSRS development functionality became available for Visual Studio 2012 in March 2013. And Microsoft started to distinguish between SSDT and SSDT-BI (which contains the BI tools). They are complementary installations, and both must be installed for Visual Studio to be happy working with SSRS reports.

The components needed for SSRS development are as follows:

• Download SSDT for Visual Studio 2012
• Download SSDT-BI for Visual Studio 2012
• Download Data-Tier Application Framework (March 2013)

Answer 2

Check out this blog post. Basically, there are two versions of SSDT (even though Microsoft doesn't ever explicitly state this), and depending on how you installed SSDT, you get one or the other version. As a further note, SSDT will only work with BIDS in SQL Server 2012, not 2008R2.