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
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.
You can also open Visual Studio 2008 and navigate to Help --> About Microsoft Visual Studio and look for the following components to be installed.
- SQL Server Analysis Services
- SQL Server Reporting Services
- SQL Server Integration Services
- query multiple IIF statement
- count distinct values while left joining
- MySQL: Order by Count(*)?
- How to select data items of a certain length?
- Comparing JSON-typed column with specific string value
- How to treat MAX() of an empty table as 0 instead of NULL
- Declare variable in SQLite and use it
- Is there any better option to apply pagination without applying OFFSET in SQL Server?
- Snowflake: Using multiple AND/OR statements breaks my date filter
- How to get the insert ID in JDBC?
- Add a column to a DB2/400 table with a specific ordinal position
- SQL conditional MAX extraction
- Drop Column from Large Table
- Can using isnull in a where statement cause problems with using indexes?
- How do I correctly use two Not Exists statements in a where clause using Access SQL VBA?
- SQL Concat Subquery
- Oracle client appears to be transmitting all 4000 varchar characters for each row
- Java JDBC executeUpdate not working on Delete SQL with TRUNC function in where clause
- Oracle thinks table doesn't exist during alter
- How to bulk update sequence ID postgreSQL for all tables
- Remote clickhouse error: DB::Exception: There's no column '__table1.event_params.key' in table '__table1'
- How do I catch a query exception in laravel to see if it fails?
- How can I use LEFT & RIGHT Functions in SQL to get last 3 characters?
- SQL Stored Procedures not finishing when called from Python
- Make a paginated table without offset limit
- How to DROP multiple columns with a single ALTER TABLE statement in SQL Server?
- How do composite indexes work?
- Rank rows by specified partition
- SQL Get "ISO Year" for ISO Week
- How to insert an array value to an existing JSON document?