Error on SQL Server 2005: "Create maintenance plan failed"

The cause of this error is lack of  Integration Services (SSIS) service when installing SQL server 2005.

When you create the maintenance plan, the following code is run.

EXEC msdb.dbo.sp_update_jobstep @job_name=N'System DB Maintenance Plan', @step_id=1 , @subsystem=N'SSIS', @command=N'/SQL 
"\Maintenance Plans\System DB Maintenance Plan" /SERVER ASHBSQL701 /MAXCONCURRENT " -1 " /CHECKPOINTING OFF'

This code tries to access the Integration Services service.

The solution is to install back the Integration Services from the SQL server 2005 setup CD

Ref: http://support.microsoft.com/kb/909036