Install Visual Studio 2008 Service Pack 1.Uninstall all of these if you already have them installed in your environment:.In order to get both set of templates in the same development environment, you need to install both Visual Studio 2008 and BIDS in the right order as described in the following steps: So how do you get both set of templates in a single development environment?
You get the same error if you have Visual Studio 2008 installed by itself and try to open one of the Business Intelligence projects. The reason behind these errors is that BIDS 2008 / 2008 R2 does not come with the database project template and Visual Studio 2008 does not come with the SSIS, SSAS, and SSRS Business Intelligence project templates. If you have BIDS 2008 / 2008 R2 installed by itlself and you try to open a database project you get an error saying that this type of project is not supported. Database projects are supported by Visual Studio 2008 Developer, Professional and Team System Database Editions. The SSIS, SSAS, and SSRS Business Intelligence projects are supported by the Visual Studio 2008 shell that comes with SQL Server 2008 / 2008 R2. If you're insisting on installing Visual Studio of a specific version you need to look into SQL Server data tools.Working with the SSIS, SSAS, and SSRS Business Intelligence projects along with Database projects in the same Visual Studio 2008 development environment can be challenging as there is no clear documentation how to enable both set of projects. Installing BIDS has no prerequisite on Visual Studio or SSDT and SSDT has no influence whatsoever on the installer you are running.Īlso, BIDS is by definition Visual Studio 2008 as explained hereīusiness Intelligence Development Studio is Microsoft Visual StudioĢ008 with additional project types that are specific to SQL Server
Have a look at Features Supported by the Editions of SQL Server 2008 R2 which clearly states that the regular express doesn't have BIDS and the Express with advanced services does have BIDS. Make sure you install the Microsoft SQL Server2008 R2 RTM - Express with Advanced Services as that is the only one including BIDS. From your screenshot I judge that you are using the Express installer (It says: Select the express features to install), SSDT and Visual Studio 2010 have no influence on the options in this installer.
0 kommentar(er)
