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
- Return time difference in the format hh:mm:ss in SQL
- Getting only Month and Year from SQL DATE
- Retrieving Most Recent Status Value before A given transaction date
- Can't remove single Quote in SQL
- How do I get matched pairs of results (1 male and 1 female) with the same age at random?
- SQL Server Operating system error 5: "5(Access is denied.)"
- ERROR: extra data after last expected column on PostgreSQL while the number of columns is the same
- How to get the 30 days before date from today's date
- How to get the date 30 days before today's date from database
- What are the disadvantages to Indexes in database tables?
- Default parameter in SQL where clause
- How to display full text and all rows in DuckDB console results?
- How can I filter words in SQL using a function?
- Getting the second occurrence from charindex function in sql server
- Search a PHP array for number of characters
- Microsoft Access: How to pass parameter from main query to subquery
- Get number of Oracle DB transactions
- SQL vs CODE, Where is the balance?
- postgres locking with UPDATE FOR and foreign keys
- Inserting root id to all its children
- How do databases maintain results if another query edits those results
- Transaction deadlock for select query
- MySQL MAX() function returns NULL on empty table - How to get an empty result set instead?
- Crosstab in SQL Server with a column that may have no data
- How can I translate the FileNet ID ID in DB2/Oracle into friendly GUID?
- Many to Many Self referencing relationship
- MS Access error "ODBC--call failed. Invalid character value for cast specification (#0)"
- How to instantiate user @variables?
- Issue with parameters of SQLAlchemy execute()
- Multiple select queries with union, flatten to single row