The error message posted on the subject above refers to install relevant client tools or services in order to continue the task you are running.
You may be aware that SQL Server setup offers installation of various services such as Analysis Services, Reporting Services, Integration Services and so on when you don't need them simply do not tick during the setup installation. Similar to this I found one problem when using SQL Server 2008 x64 installation and chosen to install DB Engine and INtegration services for obvious usage of ETLmanagement.
When it is complete and all ready for Application usage, DBAs has strike with 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.
The initial thought of the error clearly states that it is unable to find Integration Services to continue the package creation of backup database job, by default creation of Maintenance Plans results in the creation of SSIS packages. Therefore, SSIS is required in order to execute a maintenance plan.If you are using any third party applications that may not refer to install SSIS services on the server, you have to install the Integration Services to continue the tasks.Further to this during the setup when tried to install Integreation Services itfailed that has not reported by unattended installation process, as you are aware that previous to SQL Server 2005 SP2 onwards the Database Maintenance plans were integreated with SSIS but after SP2 Microsoft has changed that do not need SSIS to be installed to run maintenance jobs.
To resolve this issue in SQL Server 2008 the latest release of Cumulative UPdate 3 has got the fix as per the KBA96116 link:
"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. "