Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2008 Forums
 SQL Server Administration (2008)
 Trying to do a maintenance plan backup

Author  Topic 

icw
Constraint Violating Yak Guru

378 Posts

Posted - 2010-12-11 : 10:55:55
Hi
I have SQL 2008 Workgroup edition
I have set up a maintainence plan to do a back up but it keeps failing with the following message
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.
I did some reading which told me this would be fixed if I put on the latest Service pack.
I have doen this and am still getting the error.
Heres the version
Microsoft SQL Server 2008 (SP2) - 10.0.4000.0 (X64) Sep 16 2010 19:43:16 Copyright (c) 1988-2008 Microsoft Corporation Workgroup Edition (64-bit) on Windows NT 6.0 <X64> (Build 6002: Service Pack 2)

nigelrivett
Master Smack Fu Yak Hacker

3385 Posts

Posted - 2010-12-12 : 10:04:53
Is the integration services service staerted?


==========================================
Cursors are useful if you don't know sql.
SSIS can be used in a similar way.
Beer is not cold and it isn't fizzy.
Go to Top of Page

Sachin.Nand

2937 Posts

Posted - 2010-12-13 : 07:43:36
First check whether the SQL Serve Integration service is installed.
Goto RUN>>type Services.msc and then look for the "SQL Server Integration Services" in the list.

PBUH

Go to Top of Page
   

- Advertisement -