I'm not that familiar with redgate's sqlbackup proc, but if it throws and error you should be able to bubble that error up and handle in SSIS either through a...
We are in the process of upgrading as well, and the main reason is the XML features, second is the Service Broker. I work in an environment where we use...