sqlsql-server-2008visual-studio-2008

Is there a way to add Business Intelligence Projects templates to Visual Studio 2008?


From what I understand, it should automatically have it installed. What I have installed right now is SQL Server 2008 R2 and Visual Studio 2008 Developer.

Thanks, Fahad


Solution

  • If you installed the SQL Server 2008 R2 client tools, you will see the Business Intelligence project templates in Visual Studio 2008.

    So, make sure that you installed SQL Server 2008 R2 client tools and not just the Express edition.

    Check the following link to understand which SQL Server editions support Business Intelligence Development Studio (BIDS).

    Features Supported by the Editions of SQL Server 2008 R2 - Development Tools

    Follow this link to find the steps to install SQL Server client tools.

    SQL Server 2008 Client Tools Installation

    Update:

    If you have the SQL Server 2008 R2 Client tools installed, you should see a folder in the Windows Start --> All Programs option. Within that you should see SQL Server Business Intelligence Development Studio. If you don't, then you don't have the client tools installed.

    BIDS

    You can also open Visual Studio 2008 and navigate to Help --> About Microsoft Visual Studio and look for the following components to be installed.

    Help