Tuesday, May 04, 2010 1:06 PMI 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?
Tuesday, May 04, 2010 1:17 PM
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
Sunday, April 29, 2012 9:57 AMSo is the most uptodate BIDS vs 2008? Or is there any other new VS which supports report development (SSRS)?
Sunday, April 29, 2012 12:36 PM
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.
Tuesday, May 01, 2012 6:00 AM
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:
Wednesday, May 02, 2012 2:26 AM
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.
Wednesday, May 02, 2012 9:30 AM
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?