locked
Business Intelligence Development Studio RRS feed

  • Question

  •      I am using  VS  2010 and SQL  Server 2008 R2 but  my query is how to implement business intelligence tools in that.
    Saturday, August 11, 2012 9:35 AM

Answers

  • Hi Sathish samy,

    Microsoft Visual Studio 2010 does not support Business Intelligence Development Studio Integration Services, Report Services and Analysis Services projects for SQL Server 2008 and SQL Server 2008 R2. To work around this issue, you can install Visual Studio 2008 alongside Visual Studio 2010 on the same machine and then open the Business Intelligence Development Studio projects in Visual Studio 2008.

    Thanks,
    Eileen


    Please remember to mark the replies as answers if they help and unmark them if they provide no help. This can be beneficial to other community members reading the thread.

    • Marked as answer by Eileen Zhao Tuesday, September 4, 2012 7:56 AM
    Monday, August 27, 2012 3:05 AM

All replies

  • Hi Satish,

    You'll need to install SQL Server 2012 data tools available for download here - http://msdn.microsoft.com/en-us/data/hh297027

    Also, see this - http://www.sqlservercentral.com/blogs/jamesserra/2012/07/25/visual-studio-2012-does-not-support-bi/#comments

    Hope this helps!


    Shahfaisal Muhammed http://shahfaisalmuhammed.blogspot.com


    Saturday, August 11, 2012 3:08 PM
  • which edition of SQL Server 2008 R2 do you have? Express, Standard, developer, etc? I am pointing this out because not all editions come with "BI" features - like express edition does not have BI features.

    Paras Doshi (Blog: ParasDoshi.com | Twitter: @Paras_Doshi )

    Saturday, August 11, 2012 8:30 PM
  • SQL Server 2008 R2 integrates with VS 2008. There is no way to make it work with VS 2010.

    To use VS 2010, you need to upgrade to SQL Server 2012.


    Tatyana Yakushev [PredixionSoftware.com]

    • Proposed as answer by koles Friday, August 17, 2012 6:25 AM
    • Marked as answer by Eileen Zhao Monday, August 27, 2012 3:01 AM
    • Unmarked as answer by Eileen Zhao Monday, August 27, 2012 3:02 AM
    Monday, August 13, 2012 4:55 PM
    Answerer
  • Hi Sathish samy,

    Microsoft Visual Studio 2010 does not support Business Intelligence Development Studio Integration Services, Report Services and Analysis Services projects for SQL Server 2008 and SQL Server 2008 R2. To work around this issue, you can install Visual Studio 2008 alongside Visual Studio 2010 on the same machine and then open the Business Intelligence Development Studio projects in Visual Studio 2008.

    Thanks,
    Eileen


    Please remember to mark the replies as answers if they help and unmark them if they provide no help. This can be beneficial to other community members reading the thread.

    • Marked as answer by Eileen Zhao Tuesday, September 4, 2012 7:56 AM
    Monday, August 27, 2012 3:05 AM