SSIS package failed to open

  • Hello Team,

    I have installed Sql Server 2008 R2 in my local machine and when I tried to open SSIS solution on my local machine I am getting below error:

    "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 R2: Standard, Enterprise, Developer, or Evaluation. To install Integration Services, run SQL Server Setup and select Integration Services."

    Please help me to get rid of this with a possible solution.

    Thanks,

    Mohammed Aala

  • Just wondering but did you search that error message on Bing or Google?

    Have you gone through this KB article?

    FIX: You cannot edit or debug an SSIS package in BIDS when SQL Server 2008 Enterprise Edition, Standard Edition, Developer Edition, or Evaluation edition is installed without the SSIS feature

    Shawn Melton
    Twitter: @wsmelton
    Blog: wsmelton.github.com
    Github: wsmelton

  • mohammedaala (10/26/2014)


    Hello Team,

    I have installed Sql Server 2008 R2 in my local machine and when I tried to open SSIS solution on my local machine I am getting below error:

    "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 R2: Standard, Enterprise, Developer, or Evaluation. To install Integration Services, run SQL Server Setup and select Integration Services."

    Please help me to get rid of this with a possible solution.

    Thanks,

    Mohammed Aala

    The obvious question:

    did you install SSIS on the machine?

    Need an answer? No, you need a question
    My blog at https://sqlkover.com.
    MCSE Business Intelligence - Microsoft Data Platform MVP

  • Koen Verbeeck (10/27/2014)


    mohammedaala (10/26/2014)


    Hello Team,

    I have installed Sql Server 2008 R2 in my local machine and when I tried to open SSIS solution on my local machine I am getting below error:

    "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 R2: Standard, Enterprise, Developer, or Evaluation. To install Integration Services, run SQL Server Setup and select Integration Services."

    Please help me to get rid of this with a possible solution.

    Thanks,

    Mohammed Aala

    The obvious question:

    did you install SSIS on the machine?

    +1, search for the SQL Server Business Intelligence Development Studio, in the program menu if its not there, then you need to install it.

  • Yes I have installed Sql Server 2008 R2 and also SP3 and SSRS is working fine but SSIS package coming errors. I have already posted with attachments. But still could not be able to run SSIS 🙁

  • mohammedaala (10/27/2014)


    Yes I have installed Sql Server 2008 R2 and also SP3 and SSRS is working fine but SSIS package coming errors. I have already posted with attachments. But still could not be able to run SSIS 🙁

    That's not what we asked. Did you install Integration Services?

    Need an answer? No, you need a question
    My blog at https://sqlkover.com.
    MCSE Business Intelligence - Microsoft Data Platform MVP

  • Yes, SSIS is installed. I have attached here with the screenshot. Please check...

Viewing 7 posts - 1 through 6 (of 6 total)

You must be logged in to reply to this topic. Login to reply