Business Intelligence Project Template


  • Having scoured the net, I haven't seen any information on how to open a .rptproj (Business Intelligence Project) in Visual Studio 2008.  The only things I have read imply that the lack of obvious support might mean that the only reporting services project that Visual Studio 2008 will be able to manage will be SQL Server 2008 reporting services projects.


    Hopefully this is not the case.  Given the fact that SQL Server 2008 is still beta and customers will not be likely to immediately upgrade to SQL Server 2008, the new Visual Studio should support managing SQL Server 2005 Reporting Services projects as well.


    Hopefully someone can shed light on how to install the Business Intelligence Project Template in Visual Studio 2008.



    Brian Orrell

    Pariveda Solutions

    Saturday, November 24, 2007 10:32 PM

All replies

  • Same question here!  Have you heard anything????




    Monday, November 26, 2007 5:58 PM
  • AFAIK Busines Intelligence Studio IDE is a part of SQL and we wont be able to open the SQL related projects in the Visual Studio IDE ( i believe its the same with VS2005).... or am i missing something.

    • Proposed as answer by Mike Yeager Tuesday, February 17, 2009 2:55 PM
    Monday, November 26, 2007 8:25 PM
  • Right, the business intelligence project templates are installed when SQL Server is installed. for now, it appears that the SQL Server 2005 install does NOT install these templates in VS2008, so all of these project types are unavailable in VS2008. For example, if you created some SSIS packages in VS2005, you can not open them in VS2008.


    The question is - do we have to wait until SQl Server 2008 is released before we can work on these projects in VS2008? Is there no way to use the SQL2005 install to allow us to work in VS2008 while we wait for that?





    Monday, November 26, 2007 8:31 PM

    I guess you might have to wait( but this is not a official word from MS)... As a try we can try installing SQL server 2005 after installing VS2008 and see if that brings any templates.
    Monday, November 26, 2007 8:49 PM
  • Installing SQL 2005 after VS2008 does not really help in displaying the Business Intelligence projects. However, you could continue to use VS2005 for SSIS package, reporting and other stuff.



    Monday, December 03, 2007 10:24 PM
  • Any resolution to this issue?





    Friday, January 25, 2008 10:11 PM
  • You have got to be freaking kidding me?!?!?!


    Why does Microsoft CONSTANTLY pull stuff like this!!!


    "We want you to use this awesome new great product, but guess what?!?! All the stuff you created in the old version ain't gonna work with the new product!!!"


    Seriously...who are the people behind these decisions? What...we're supposed to use two versions of Visual Studio until Microsoft gets its act together?!?!


    Seriously p*ssed off about this...


    Thursday, May 08, 2008 4:46 PM
  • I also cannot believe what I am seeing here! I just upgraded to VS 2008, and now cannot edit my RS 2005 reports???

    Is there anyone within Microsoft who will please let us know what is going on here?
    Saturday, January 10, 2009 5:39 PM
  • I don't have to be Microsoft to tell you if you are not running Team Suites or Team Database developer edition you open SQL Server 2005 SSRS projects with the free BI studio VS2005 edition and you open SQL Server 2008 SSRS project with the free BI studio VS2008 edition.  Both BI studio VS2005 or VS2008 can only be used for BI project and not .NET development.

    Sunday, January 11, 2009 1:32 AM
  • I installed VS 2010 Beta, but I see nothing in the VS for Database projects. I have SQL Server 2008 Express (plan to install Development version a bit later). In VS 2008 I was able to create SSRS project.

    How can I create BI projects from VS 2010 Beta?

    Premature optimization is the root of all evil in programming. (c) by Donald Knuth

    Naomi Nosonovsky, Sr. Programmer-Analyst

    My blog
    Tuesday, January 05, 2010 2:31 PM
  • You need to download and install the Ultimate which replaces the old Team Suites it comes with BI and other database projects template because it can be used to create SQL Server databases and objects.

    • Edited by CaddreModerator Tuesday, January 05, 2010 5:43 PM Link enabled
    • Proposed as answer by Naomi N Tuesday, January 05, 2010 9:11 PM
    Tuesday, January 05, 2010 5:41 PM
  • Hi,
    I'm using SQL Server 2008 R2 and VS 2010 Premium which should have all the database development stuff.
    But I still can't figure out how to create BI (SSIS) projects in VS.

    Do I have to install SQL 2008 BI Studio? Or can I work with VS 2010?
    Thursday, January 21, 2010 9:53 AM
  • The link below shows you can use BIDS 2008 and use the targeting feature of VS2008 to either develop for SQL Server 2008 or 2008 R2.


    Sunday, January 24, 2010 3:19 PM
  • Where can I get the Free BI Studio VS2008 edition download from?
    Thursday, July 29, 2010 3:03 PM
  • Where can I get the Free BI Studio VS2008 edition download from?


    You get the free BI studio when you install SQL Server for pay editions like the under $40. no deployment restricted developer edition.  However the free Express edition comes with a limited version you can use to develop local mode SQL Server Reports.

    Sunday, August 08, 2010 8:59 PM