Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
Log in  ::  Register  ::  Not logged in

James Serra's Blog

James is currently a Senior Business Intelligence Architect/Developer and has over 20 years of IT experience. James started his career as a software developer, then became a DBA 12 years ago, and for the last five years he has been working extensively with Business Intelligence using the SQL Server BI stack (SSAS, SSRS, and SSIS). James has been at times a permanent employee, consultant, contractor, and owner of his own business. All these experiences along with continuous learning has helped James to develop many successful data warehouse and BI projects. James has earned the MCITP Business Developer 2008, MCITP Database Administrator 2008, and MCITP Database Developer 2008, and has a Bachelor of Science degree in Computer Engineering. His blog is at .

Watch out, Visual Studio 2010 does not support BI

When Visual Studio 2010 was released about a year ago, I was very excited and wanted to quickly open up a SSAS project created in VS 2008 to see the new features that were available in VS 2010.  So I copied one of my projects to a test folder and proceeded to open that project in VS 2010.  I was greeted with a “Welcome to the Visual Studio Conversion Wizard”.  Ok, no problem.  I run the wizard, and it completes with an “All projects converted successfully”.  Great!  But looking at the Solution Explorer, I see that it shows the solution as “unavailable”, and for the project is shows “The project file was unloaded”.  Strange.  So I close the solution, then open it and see this:

Really strange.  Let me try a SSIS project.  Same error.  Let me try a SSRS project.  Same error.  I spent the next few hours trying to figure out what I was doing wrong to cause the conversion not to work.  Finally I turn to my friend Mr. Google, and find this interesting bit:  VS 2010 does not support SSAS, SSIS, or SSRS!  Not only that, but the conversion wizard converts the project into a format it can’t use in VS 2010 AND VS 2008!  That just does not make any sense.  Why didn’t VS 2010 just say “Sorry, SSAS, SSIS, and SSRS are not supported” when you try to open the VS 2008 solution in VS 2010?  Instead, it converts it into a format nothing can use.

Very frustrating.  But at least there is a pretty easy way, via the previous link, to perform a few steps so you can once again open the solution in VS 2008.  I just hope you don’t waste hours thinking you were doing something wrong with the conversion like I did.

In the next version of SQL Server, code named ”Denali”, all the current “BIDS” components (SSIS, SSAS, SSRS) will be shipping on top of the Visual Studio 2010 shell.  With CTP1 of Denali, BIDS is still based on Visual Studio 2008.  In the next CTP, due this summer, it will use the 2010 shell.  This new environment is code-named “Juneau”.


No comments.

Leave a Comment

Please register or log in to leave a comment.