SQL 2005, SSIS and maintenance plans.

I ran into an instance today where I had deployed SQL 2005 Standard edition (using default options) onto a server that was going to be a dedicated server for a line of business application for one of my clients. Once the software vendor had migrated the database onto this server and configured the LOB app accordingly, I was tasked with setting up a maintenance plan and just generally finessing the configuration (enabling Shadow Copy etc..). When going through and configuring the maintenance plan, I received an error that stated:

<snip>
TITLE: Maintenance Plan Wizard Progress

Create maintenance plan failed.
-----------------------------

ADDITIONAL INFORMATION:

Create failed for JobStep 'Subplan'.  (Microsoft.SqlServer.MaintenancePlanTasks)

For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=9.00.1399.00&EvtSrc=Microsoft.SqlServer.Management.Smo.ExceptionTemplates.FailedOperationExceptionText&EvtID=Create+JobStep&LinkId=20476

------------------------------
An exception occurred while executing a Transact-SQL statement or batch. (Microsoft.SqlServer.ConnectionInfo)
------------------------------

The specified '@subsystem' is invalid (valid values are returned by sp_enum_sqlagent_subsystems). (Microsoft SQL Server, Error: 14234)

For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=09.00.1399&EvtSrc=MSSQLServer&EvtID=14234&LinkId=20476
</snip>

Of course, as I have found to be the case typically, the links provided in the error dont turn up much of anything useful. I then proceeded poking around Google and I found that this error occurs when creating a scheduled maintenance plan in an installation that is lacking SSIS (SQL Server Integration Services). This is documented as a known issue under KB909036. I followed the instructions in this KB article and found that it worked flawlessly once I has SSIS installed.