SSIS 2008 Error when running a Package Installation

  • I have created an SSIS package using BIDS. The package does not have any connections to a database.

    I have built the package to the bin folder.

    When I navigate to the folder and double click the package the 'Welcome to the Package Installation Wizard' opens and the following error message appears

    ERROR: The Package Instllation Wizard requires Integration Services to be installed by one of these editionsof SQL Server 208 R2: Standard, Enterprise, Developer or Evalation. To install Integration Services, run SQL Server Setup and select IntegrationServices.

    When I have searched for this error on the website it suggests a later SQL Server 2008 Service Pack should be applied to the SQL Server. My machine does not contain SQL Server it is installed on a server and the package does not contain any connections so I cannot understand why this is failing.

  • system243trd (10/21/2013)


    I have created an SSIS package using BIDS. The package does not have any connections to a database.

    I have built the package to the bin folder.

    When I navigate to the folder and double click the package the 'Welcome to the Package Installation Wizard' opens and the following error message appears

    ERROR: The Package Instllation Wizard requires Integration Services to be installed by one of these editionsof SQL Server 208 R2: Standard, Enterprise, Developer or Evalation. To install Integration Services, run SQL Server Setup and select IntegrationServices.

    When I have searched for this error on the website it suggests a later SQL Server 2008 Service Pack should be applied to the SQL Server. My machine does not contain SQL Server it is installed on a server and the package does not contain any connections so I cannot understand why this is failing.

    What are you trying to do and what is your question?

    The absence of evidence is not evidence of absence
    - Martin Rees
    The absence of consumable DDL, sample data and desired results is, however, evidence of the absence of my response
    - Phil Parkin

  • I thought I explained it fine, but here goes again

    I am trying to run an SSIS package an install it on a file system - here are the steps I'm taking .....

    1) Created a package in SSIS which worked succesfuly

    2) When I navigate to the folder where the package has been created - I double click the file and the package installation page opens but I receive the following error message

    ERROR: The Package Instllation Wizard requires Integration Services to be installed by one of these editionsof SQL Server 208 R2: Standard, Enterprise, Developer or Evalation. To install Integration Services, run SQL Server Setup and select IntegrationServices.

  • system243trd (10/21/2013)


    I thought I explained it fine, but here goes again

    I am trying to run an SSIS package an install it on a file system - here are the steps I'm taking .....

    1) Created a package in SSIS which worked succesfuly

    2) When I navigate to the folder where the package has been created - I double click the file and the package installation page opens but I receive the following error message

    ERROR: The Package Instllation Wizard requires Integration Services to be installed by one of these editionsof SQL Server 208 R2: Standard, Enterprise, Developer or Evalation. To install Integration Services, run SQL Server Setup and select IntegrationServices.

    Packages do not need to be 'installed'. You can just copy the package to your server and run it from there.

    The absence of evidence is not evidence of absence
    - Martin Rees
    The absence of consumable DDL, sample data and desired results is, however, evidence of the absence of my response
    - Phil Parkin

  • I don't want to run the package from the Server I want to be able to run it from my PC.

  • system243trd (10/21/2013)


    I don't want to run the package from the Server I want to be able to run it from my PC.

    Then you need to install Integration Services.

    More info: When is DTEXEC installed?

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

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

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