The strange thing is that all of the tasks execute cleanly. There are no errors in the logs. We test all of the code in SSMS before inserting it into the TSQL task in the maintenance plan. We use the maintenance plan as a tidy container.

Thanks for your help.