If you are doing data driven subscriptions, then you have to have Enterprise edition. You can fire a subscription to run right after the package finishes. IIRC you just execute SQL to fire the event for the subscription. However, I have found that if you have several reports/recipients in the subscription the subscription may fail and report no error back to the calling job. You'll just see the number of errors in the subscription list in Report Manager, in some cases you won't see any errors and you'll have to crack open the report services log to find out what went wrong. So via subscription, there is no way to handle the errors (you'll just get a user calling you up asking why they didn't receive their report), with the SSIS script task, you can include all the error handling that you want.