I had a request to go into more detail as to an implementation of the ReportService web service inside SSIS. I decided I’d take a crack at it.
Taking a snapshot of a report after a successful ETL load is a common task. You could automate this task into the ETL load by consuming the Reporting Services web service and calling the UpdateReportExecutionSnapshot method and invoking Reporting Service to take a snapshot. This could then be a catalyst for subsequent subscriptions for users who have asked to be notified when a new version of a report is ready.