locked
SQL Server Business Intelligence Development Studio - Integration Services & VS 2010 Express RRS feed

  • Question

  • I have SQL Server Business Intelligence Development Studio installed.  I clicked on that, clicked Create Project, clicked Business Intelligence Projects, clicked Integration Services Project and clicked OK.  I get this message:

    Microsoft Visual Studio is unable to load this document: to design Integration Services packages in Business Intelligence Development Studio, Integration Services has to be installed by one of these editions of SQL Server 2008: Standard, Enterprise, Developer, or Evaluation.  To install Integration Services, run SQL Server Setup and select integration Services.

     

    So, I downloaded SQL Server 2008 R2 from here:

    http://msdn.microsoft.com/en-us/evalcenter/ff459612

     

    I clicked on 'New installation or ad features to an existing installation.' I ran it and installed it.  Then, I got a message that says I need Visual Studio 2008 with SP1.  So, I downloaded and installed VS 2008 with SP1.  I checked the version of my SQL Server Business Intelligence Development Studio and I see that it is Version 3.5 SP1 (Version 9.0.30729.1 SP).  I rerun SQL Server 2008 R2 Setup, click 'New installation or ad features to an existing installation.'  Specify a free edition = Evaluation.  Next.  Accept terms of the license.  Choose ‘SQL Server Feature Installation’.  On the next screen I see a big red ‘X’ next to this:

    Previous releases of Microsoft Visual Studio 2008 Status = Failed

    When I click the ‘Failed’ message, it says: ‘A previous release of Microsoft Visual Studio 2008 is installed on this computer.  Upgrade Microsoft Visual Studio 2008 to the SP1 before installing SQL Server 2008’.  As far as I can tell, I ALREADY DID THIS. 

     

    Here’s the long and short of it.  I’d like a cheap copy of SQL Server 2008 R2.  I think it is $50.  Is that right?  Also, I am planning to download VS 2010 Express, from here:

    http://www.microsoft.com/visualstudio/en-us/products/2010-editions/express-iso

     

    I have Visual C# 2008 Express and Visual Basic 2008 Express and Visual Web Developer 2008 Express installed right now.  I haven’t used these much in the past; just used them a bit.  I’m planning to work with these technologies MUCH more in the near future.  If I get VS 2010 Express from the link I posted above, will that automatically upgrade my 2008 Express technologies?  Or, do I need to uninstall mu 2008 Express versions before I upgrade to 2010?  Finally, when I get the VS 2010 Express, will I be able to use SQL Server Business Intelligence Development Studio - Integration Services?  That’s what I really want to do!!

     

     

    Thanks everyone!!

    Saturday, September 24, 2011 1:30 PM

Answers

  • Hi Ryguy72,

    >> If I get VS 2010 Express from the link I posted above, will that automatically upgrade my 2008 Express technologies? Or, do I need to uninstall mu 2008 Express versions before I upgrade to 2010? Finally, when I get the VS 2010 Express, will I be able to use SQL Server Business Intelligence Development Studio - Integration Services?

    This may be a compatibility issue between Visual Studio 2008 and SQL Server 2008 R2.  This error maybe related to Visual Studio 2008 leaves you in an unsupported state with possible problems when using SQL Server 2008 R2. If you want to use VS 2010 Express instead of VS 2008, you can remove the VS 2008, then install the SQL Server 2008 R2 and VS 2010 Express.

    If you still want to  use the Visual Studio 2008, you can use the following 3 options:
    1) Please install VS 2008 SP1 first. Then try to install SQL Server 2008 R2. 

    2) Please uninstall VS 2008 completely and then install SQL Server 2008 R2. Then install VS 2008 RTM and immediately apply VS 2008 SP1. Just applying VS 2008 RTM after SQL Server 2008 R2 RTM installed, which will leave you in an unsupported state with possible problems when using Visual Studio.

    3) When you install SQL Server 2008 R2, don't select all of the features as below: Business Intelligence Development Studio, Integration Services, or Management Tools (Basic or Custom). After you installed VS 2008 SP1 success, please reinstall these features to re-run SQL Server 2008 R2 RTM.

    You can install the VS 2010 Express separately from the site you have provided.

    More information, please reference:
    1. RTM version of Visual Studio 2008 SP1: http://www.microsoft.com/download/en/details.aspx?displaylang=en&id=10986
    2. Actions that are required before you install SQL Server 2008 on a computer that has Visual Studio 2008 or the prerelease version of SQL Server 2008 installed: http://support.microsoft.com/kb/956139
    Regards, Amber zhang
    • Edited by amber zhang Monday, September 26, 2011 5:59 AM
    • Marked as answer by Stephanie Lv Thursday, October 6, 2011 7:54 AM
    Monday, September 26, 2011 5:58 AM

All replies

  • Rguy72,

    >>Here’s the long and short of it.  I’d like a cheap copy of SQL Server 2008 R2.  I think it is $50.  Is that right? 

    To be honest if you are planning to learn or work with integration services, get yourself a copy of SQL Server Developer edition  for about $50 (amazon.com has it) . It comes with Business intelligence Developer studio (you **do not*** need full Visual Studio paid edition)  that you can use to develop BI packages.

    • Proposed as answer by Horizon_Net Saturday, September 24, 2011 10:54 PM
    Saturday, September 24, 2011 1:37 PM
  •  

    I am running SQL Server Installation Center (SQL Server 2008 Express). – Select All

    I tried ‘Express with Advanced Services’ and ‘Evaluation’.

    SQL Server Feature Installation. – Select All

     

    In both instances, I get an error for ‘Previous releases of Microsoft Visual Studio 2008’.  The specific message is:  Previous releases of Microsoft Visual Studio 2008 Status = Failed

    When I click the ‘Failed’ message, it says: ‘A previous release of Microsoft Visual Studio 2008 is installed on this computer.  Upgrade Microsoft Visual Studio 2008 to the SP1 before installing SQL Server 2008’. 

     

    I installed, and am running, Microsoft C# Express 2010 and Microsoft Visual Web Developer 2010 Express.  I also have SQL Server Business Intelligence Development Studio, Version 9.0.30729.1 SP (Version 3.5 SP1). 

    I have to admit that I don’t know what is going on here.  I have been trying to trouble shoot this problem for a couple weeks now; making no progress on this whatsoever.  I have 2010 installed, and this keeps asking me about 2008.  I literally spent 2 hours today installing every instance of VS 2008 on my computer, and I am still getting prompts about 2008.  Does anyone know what may be causing this error?  All I want to do is run SSIS.  That’s it!!  I just want to run a basic instance of SSIS.  I have spent 2 weeks trying to get SSIS to launch!!


    • Edited by ryguy72 Sunday, September 25, 2011 2:14 PM
    • Merged by Stephanie Lv Monday, September 26, 2011 6:03 AM duplicated thread
    Sunday, September 25, 2011 7:00 AM
  •  

    I am running SQL Server Installation Center (SQL Server 2008 Express). – Select All

    I tried ‘Express with Advanced Services’ and ‘Evaluation’.

    SQL Server Feature Installation. – Select All

     

    In both instances, I get an error for ‘Previous releases of Microsoft Visual Studio 2008’.  The specific message is:  Previous releases of Microsoft Visual Studio 2008 Status = Failed

    When I click the ‘Failed’ message, it says: ‘A previous release of Microsoft Visual Studio 2008 is installed on this computer.  Upgrade Microsoft Visual Studio 2008 to the SP1 before installing SQL Server 2008’. 

     

    I installed, and am running, Microsoft C# Express 2010 and Microsoft Visual Web Developer 2010 Express.  I also have SQL Server Business Intelligence Development Studio, Version 9.0.30729.1 SP (Version 3.5 SP1). 

    I have to admit that I don’t know what is going on here.  I have been trying to trouble shoot this problem for a couple weeks now; making no progress on this whatsoever.  I have 2010 installed, and this keeps asking me about 2008.  I literally spent 2 hours today installing every instance of VS 2008 on my computer, and I am still getting prompts about 2008.  Does anyone know what may be causing this error?  All I want to do is run SSIS.  That’s it!!  I just want to run a basic instance of SSIS.  I have spent 2 weeks trying to get SSIS to launch!!


    • Edited by ryguy72 Sunday, September 25, 2011 2:14 PM
    • Moved by Todd McDermid Sunday, September 25, 2011 4:00 PM (From:SQL Server Integration Services)
    • Merged by Stephanie Lv Monday, September 26, 2011 6:02 AM duplicated thread
    Sunday, September 25, 2011 7:00 AM
  • ryguy,

    the problem is

    there is a known compatibility issue related to Visual Studio 2008 without service pack and SQL Server 2008 (becuase SQL 2008 installs some component of Visual Studio 2008 with SP1 ) and both VS 2008 without service pack and VS 2008 with service pack 1 cannot co-exist.

     

    Follow this support aricle and implement suggested workaround.

     Actions that are required before you install SQL Server 2008 on a computer that has Visual Studio 2008 or the prerelease version of SQL Server 2008 installed

    http://support.microsoft.com/kb/956139


    • Edited by Chirag Shah Sunday, September 25, 2011 6:43 PM
    • Proposed as answer by Papy Normand Sunday, September 25, 2011 7:13 PM
    Sunday, September 25, 2011 6:42 PM
  • To run SSIS you need to install the SSIS component. This is not a valid component for installation with SQL Express. You will need to use standad edition or higher (developer in a development environment)

    http://msdn.microsoft.com/en-us/library/cc645993.aspx#SSIS

    I hope this helps.


    Warwick Rudd
    MCT MCITP SQL Server 2008 Admin
    My Blog
    -------------------------------------------------------
    Please mark as Answered if I have answered your question
    Please vote if this was useful
    -------------------------------------------------------

    Sunday, September 25, 2011 9:21 PM
  • Hi Ryguy72,

    >> If I get VS 2010 Express from the link I posted above, will that automatically upgrade my 2008 Express technologies? Or, do I need to uninstall mu 2008 Express versions before I upgrade to 2010? Finally, when I get the VS 2010 Express, will I be able to use SQL Server Business Intelligence Development Studio - Integration Services?

    This may be a compatibility issue between Visual Studio 2008 and SQL Server 2008 R2.  This error maybe related to Visual Studio 2008 leaves you in an unsupported state with possible problems when using SQL Server 2008 R2. If you want to use VS 2010 Express instead of VS 2008, you can remove the VS 2008, then install the SQL Server 2008 R2 and VS 2010 Express.

    If you still want to  use the Visual Studio 2008, you can use the following 3 options:
    1) Please install VS 2008 SP1 first. Then try to install SQL Server 2008 R2. 

    2) Please uninstall VS 2008 completely and then install SQL Server 2008 R2. Then install VS 2008 RTM and immediately apply VS 2008 SP1. Just applying VS 2008 RTM after SQL Server 2008 R2 RTM installed, which will leave you in an unsupported state with possible problems when using Visual Studio.

    3) When you install SQL Server 2008 R2, don't select all of the features as below: Business Intelligence Development Studio, Integration Services, or Management Tools (Basic or Custom). After you installed VS 2008 SP1 success, please reinstall these features to re-run SQL Server 2008 R2 RTM.

    You can install the VS 2010 Express separately from the site you have provided.

    More information, please reference:
    1. RTM version of Visual Studio 2008 SP1: http://www.microsoft.com/download/en/details.aspx?displaylang=en&id=10986
    2. Actions that are required before you install SQL Server 2008 on a computer that has Visual Studio 2008 or the prerelease version of SQL Server 2008 installed: http://support.microsoft.com/kb/956139
    Regards, Amber zhang
    • Edited by amber zhang Monday, September 26, 2011 5:59 AM
    • Marked as answer by Stephanie Lv Thursday, October 6, 2011 7:54 AM
    Monday, September 26, 2011 5:58 AM