I am getting the following error when trying to run any of the Maintenance Task jobs that had been created on the server:
Message [LOG] Step 1 of job 'Weekly Backup' (0x8EC76A988468C74897562440AADD067D) cannot be run because the SSIS subsystem failed to load. The job has been suspended
The Maintenance task was originally set up months ago and ran fine about until this week. When checking the Sql Server Agent logs, I see the above error. I have tried restarting services, reboot (in case of file locks?), and I've also tried the advice from here: http://support.microsoft.com/?kbid=914171
use msdb go delete from msdb.dbo.syssubsystems exec msdb.dbo.sp_verify_subsystems 1 go
And restarting SQL Agent.
Same problem continues and the job is marked as Suspended. Any ideas?