I suggest you ...

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.

38 votes
Vote
Sign in
Check!
(thinking…)
Reset
or sign in with
  • facebook
  • google
    Password icon
    I agree to the terms of service
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    Steve TylkeSteve Tylke shared this idea  ·   ·  Admin →

    2 comments

    Sign in
    Check!
    (thinking…)
    Reset
    or sign in with
    • facebook
    • google
      Password icon
      I agree to the terms of service
      Signed in as (Sign out)
      Submitting...
      • Jason SchaitelJason 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.

      • ChristianChristian commented  · 

        Any news on this one? Is it also planned for SQL 2005 SSRS or only current versions?

      Feedback and Knowledge Base