Execute SSRS Reports from SSIS
I would like to see the ability to Execute an SSRS report from SSIS. This way when data is loaded and successful, the reports can automatically be run and then possibly emailed to the user in one single process vs having seperate ETL and Report jobs run.
Jason Schaitel commented
You can already do this by executing a subscription on on a report from within a Script Task. Of course it would be sweet to have an official TF component for this rather than a script task. The thing you have to watch out for with the method I describe above is that you can only have one subscription per report because there is no way to tell the script task firing the event which of multiple subscriptions you want executed. You can use linked reports to get around this limitation though, since each linked report can have a subscription and all be based on the original report.
Any news on this one? Is it also planned for SQL 2005 SSRS or only current versions?