Business Intelligence Templates in Visual Studio 2010

Question

I recently installed VS 2010 but I do not see the Business Intelligence Project templates for SSIS/SSAS/SSRS.  Do I need to install SQL Server R2 to have this available?

---

Javier Guillen

Answer 1

Hello Javier,

Buisness Intelligence Project templates comes along with BIDS = Business Intelligence Developer Studio of Sql Server. If you have Bids 2005, you will find the templates also in VS 2005 and Bids 2008 templates in VS 2008, but none of them actually in VS 2010.

---

Olaf Helper ----------- * cogito ergo sum * errare humanum est * quote erat demonstrandum * Wenn ich denke, ist das ein Fehler und das beweise ich täglich http://olafhelper.over-blog.de

Answer 2

So is the most uptodate BIDS vs 2008? Or is there any other new VS which supports report development (SSRS)?

---

Namnami

Answer 3

SQL Server 2012 uses VS 2010.

SQL Server 2008 and R2 use VS 2008.

SQL Server 2005 uses VS 2005.

Dependent upon which SQL Server version you're using, you'll have to use the correct VS version.

HTH, Martin

---

http://martinmason.wordpress.com

Answer 4

SQL Server 2012 uses VS 2010- how? I understood VS 2010 does not have support for BIDS? If I'll install SQL server 2012 for the SSRS server then would this upgrade my VS 2010 so SSRS reports could be developed there?
I think the following thread contradicts this:
http://social.msdn.microsoft.com/Forums/en-BZ/sqlreportingservices/thread/09f7b135-43e2-49f0-9b6b-0ff5ba56a4a5

Thanks

---

Namnami

Answer 5

There seems to be much confusion around this but it is as my original post stated. The new SQL Server Data Tools uses the VS 2010 Shell. Unlike previously though, you can use VS 2010 to deploy to SQL Server 2008, SQL Server 2008 R2, or to SQL Server 2012. There is a Target Server Version property in the Report Server project properties that specifies which version. To deploy to SSRS 2005, you'll still have to use VS 2005 or BIDS 2005.

HTH, Martin

---

http://martinmason.wordpress.com

Answer 6

So if I understand you correctly, I can work with VS2010 for report development if I install SQL server 2012 for the SSRS server?

If so, how will I make my VS 2010 be capable of BIDS?

Thanks

---

Namnami