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.
Author |
Topic |
icw
Constraint Violating Yak Guru
378 Posts |
Posted - 2010-12-11 : 10:55:55
|
HiI have SQL 2008 Workgroup editionI 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 versionMicrosoft 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. |
 |
|
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 |
 |
|
|
|
|