Re: SQL 2008 backup maintenance plan requires integration services

CK,
One workaround would be to set up a job manually and do some "Backup
database..." TSQL.
Not as comfortable as with a maintenance plan but will do the job as well...

HTH
acki4711


"CK" wrote:

I got 100% same problem!

The ability to create and edit a maintenance plan is available through SQL
Server Management Studio and there are no errors when I create such a plan.
However, when I try to run the plan an error is logged

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."


Hope someone got a workaround so we dont need to install integration service

Automated daily backup must be part of the product,

i know ot works on SQL2005 SP2

"Dan" <Dan@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:E86B4D66-EDDE-460E-8769-BBAAB4978305@xxxxxxxxxxxxxxxx
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


.

Relevant Pages

  • Re: SQL 2008 backup maintenance plan requires integration services
    ... The ability to create and edit a maintenance plan is available through SQL Server Management Studio and there are no errors when I create such a plan. ... The SQL Server Execute Package Utility requires Integration Services to be installed by one of these editions of SQL Server 2008: ... To install Integration Services, run SQL Server Setup and select Integration Services. ...
    (microsoft.public.sqlserver.setup)
  • =?iso-8859-1?Q?Treffen_der_PASS_Regionalgruppe_K=F6ln/Bonn/D=FCsseldorf_a?= =?iso-8859&#
    ... Erweiterung der Integration Services um eigene Tasks, ... Bei der Entwicklung von Integration Services Paketen ist manchmal die Nutzung des Skripttasks notwendig. ... Ziel dieses Vortrags ist die Entwicklung von benutzerdefinierten Tasks im SQL Server 2008 zu demonstrieren. ... Als Microsoft Certified Trainer und Consultant ist er europaweit im Einsatz sein Wissen in Profitrainings oder bei der Entwicklung vor Ort weiterzugeben und anzuwenden. ...
    (microsoft.public.de.sqlserver)
  • Re: SBS 2003 R2 SQL Server 2005 Maintenance Plan Doesnt WORK
    ... Maintenance Plan in SQL Server 2005. ... Microsoft CSS Online Newsgroup Support ... you may want to contact Microsoft CSS directly. ...
    (microsoft.public.windows.server.sbs)
  • Re: SQL2005 SP1
    ... EventID: 7000 Source: Service Control Manager ... The SQL Server Integration Services service failed to start due to the ... The SQL Server Integration Services (SSIS) service does not start ...
    (microsoft.public.de.sqlserver)
  • The task Transfer SQL Server Objects Task cannot run on this edition...
    ... error code: 0xc0012024 Description: The task Transfer SQL Server Objects ... Using "Integration Services Project" template in Business Intelligence ... Using platforms Visual Studio 2005 along with SQL Server 2005. ... It requires higher level edition. ...
    (microsoft.public.sqlserver.dts)
Loading