Are BI projects for SQL Server 2005/2008 compatible to apply in Visual Studio 2010?

Below are the table to list out the compatible:-

	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

Resolution to apply BI projects into Visual studio 2010

To resolve the issue in which you cannot open the project in SQL Server BIDS after you upgrade the project, follow these steps:

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.

About Yeoh Eik Den

I am a SharePoint developer, and I like to bringing a visual exploration of the dot net in the real world.

This entry was posted in BI and tagged BI. Bookmark the permalink.