SQL Server Performance

sql 2008 backup maintenance plan requires integration services ??

Discussion in 'SQL Server 2008 Questions [Archive Only - Closed]' started by acki4711, Oct 20, 2008.

  1. acki4711 Member

    Hi all,
    After installing sql 2008 ent. on x64 (only db server engine and management studio) I set up a maintenance plan for backing up the db's.
    Plan/Job is created but job does not execute. Gives the following error:
    SQL Server Execute Package Utility Version 10.0.1600.22 for 64-bit Copyright (C) Microsoft Corp 1984-2005. All rights reserved. The SQL Server Execute Package Utility requires Integration Services 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. The package execution failed. The step failed.
    Remember having the same problem with early versions of sql 2005. Installing integration service is not a option!
    Is there a workaround ?
    TIA
    acki
  2. satya Moderator

    What edition of SQL 2008 you have installed?
    I haven't seen such issue so far.
  3. Bob L New Member

    The creation of Maintenance Plans results in the creation of SSIS packages. Therefore, SSIS is required in order to execute a maintenance plan.We had the same situation happen with SQL Server 2005 Standard 32bit. When the sys admin started to create and run the new maintenance plans, they received the same message. The vendor chose not to install SSIS when they originally set up the system. Running the install and choosing just the SSIS options for the existing instance did the trick, although it doesn't have full capabilities for some reason. It doesn't let her create subtasks. Only main ones. The icon next to the maintenance plans looks different, also. However, the maintenance plans run normally, otherwise. Just have to create a maintenance plan for each task. One issue seems to be the absence of the ability to see Object Explorer Details. Just Object Explorer. Anyone have any thoughts on that one?Your results may vary....Hope this helps...
  4. acki4711 Member

    Bob,
    We have several installations of SQL 2005 Ent./Std. SP2 + HF on 32 and 64 bit. In none of the installations we install SSIS and backing up db's with maintenanceplans works ok.
    I remember having the problem of not running maintenance plan backups because of missing SSIS with early versions of sql 2005 (can't remember how and when this was fixed).
    HTH
  5. gurucb New Member

    Before SQL Server 2005 SP2 was released Maintenance plans were integreated with SSIS but after SP2 Microsoft has changed that and we do not need SSIS to be installed to run maintenance jobs. And it carried over to SQL Server 2008 though I did nto check with sQL Server 2008
  6. Bugbait New Member

    Cumulative update 3 and beyond will fix this otherwise install Intergration Services
    http://support.microsoft.com/kb/961126
    "You install the SQL Server 2008 Client Tools. However, you do not have SQL Server 2008 Integration Services installed. When you create and then execute a maintenance plan, you receive the following error message in the job history:
    The SQL Server Execute Package Utility requires Integration Services 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. The package execution failed. The step failed. "
    Bugbait out

Share This Page