- You have a Business Intelligence (BI) project. For example, you have a Microsoft SQL Server Analysis Services project, a Microsoft SQL Server Integration Services project, a Microsoft SQL Server Report Model project, or a Microsoft SQL Server Reporting Services project.
- The solution and projects have the following file name extensions:
- The BI project is created by using SQL Server Business Intelligence Development Studio (BIDS) in one of the following SQL Server versions:
- Microsoft SQL Server 2005
- Microsoft SQL Server 2008
- Microsoft SQL Server 2008 R2
- You upgrade the project to the format that is used by Microsoft Visual Studio 2010.
- You cannot open the project in Visual Studio 2010. In the Solution Explorer window, the project name will be dimmed with the word (unavailable) in parentheses next to the name of the project.
- You cannot open the project in SQL Server BIDS after you upgrade the project.
- The project in Solution Explorer Window will list the following error: The project file was unloaded.
This error indicates that Solution Explorer does not have a matching project type to open the project with.
- You try to open the project file by double-clicking it, you receive the following error:Microsoft Visual Studio
'Drive:\Path\Project_name.dwproj' cannot be opened because its project type (.dwproj) is not supported by this version of the application.
To open it, please use a version that supports this type of project.
- Create a new project that has the same name as the original BI project in a different directory by using SQL Server BIDS.
- Add all relevant project items from the upgraded BI project folder. For example, for an Analysis Services project, add the .ds and .dsv files. For a Reporting Services project, add the .rds and .rdl files.
- Save and then open the new BI project.
You use Visual Studio 2010 to open a BI project that was created by using BIDS in SQL Server 2005, in SQL Server 2008, or in SQL Server 2008 R2. In this situation, Visual Studio 2010 prompts you to upgrade the project to the Visual Studio 2010 format. Earlier versions of Visual Studio do not support opening projects from a future version of Visual Studio. Therefore, you cannot open the upgraded project in the version of BIDS that you used to create the project.
The following table lists the configurations that are supported so that you can open and edit different BI projects by using different Visual Studio versions. BI projects that are created by using BIDS cannot be edited in Visual Studio 2010. If you have a solution that contains BI projects and other projects, we recommend that you back up the solution before you open the solution in Visual Studio 2010.
|Visual Studio 2005 (the release version and later service packs) with BIDS in SQL Server 2005||Visual Studio 2008 (Service Pack 1 and later service packs) with BIDS in SQL Server 2008||Visual Studio 2008 (Service Pack 1 and later service packs) with BIDS in SQL Server 2008 R2||Visual Studio 2010 (the release version and later service packs)|
|SQL Server 2005 BI projects||Supported||Supported after project upgrade||Supported after project upgrade||Not supported|
|SQL Server 2008 BI projects||Not supported||Supported||Supported after project upgrade||Not supported|
|SQL Server 2008 R2 BI projects||Not supported||Not supported||Supported||Not supported|
Article ID: 983332 - Last Review: Mar 24, 2011 - Revision: 1