Post reply

ReportServer.dbo.AddEvent stored proc on dbo.Event table not feasible to trigger SSRS through SSIS

  • August 14, 2013 at 1:22 am

    #281167

    Hi,

    I have designed some SSRS Reports. My requirements state that I need to trigger an email of the same reports through SSIS. I used the process explained in the below mentioned link of feeding the Subscription ID of the SSRS report into the SQL task of the SSIS.

    http://www.sqlservercentral.com/articles/Integration+Services+(SSIS)/96275/

    However, since this process uses system databases (the stored procedure uses ReportServer.dbo.AddEvent stored proc on dbo.Event table) ,so I am not being provided the access to the same. Please provide me an alternative to this process, if possible.

    My sole requirement is to trigger an email of the SSRS reports through SSIS. Thank you in advance.

    Thanks and Regards,

    Prasune Verma

  • August 15, 2013 at 11:19 am

    #1641877

    Barring a TSQL solution, I have done this in the past with a scripting object that calls to the report server via URL.

    THIS[/url] link provides a good overview of a fully parameterized solution, and will give you an idea of what to investigate if you have more specialized needs.

    Good luck!

    EJM

  • November 21, 2013 at 9:46 pm

    #1668292

    Hi, Thanks for sharing my post, I have also explained another possible approach. Please go through it and let me know your comments.

    [/url]

    Thanks

    sunilreddy
    http://msbimentalist.wordpress.com 🙂

  • November 22, 2013 at 2:39 am

    #1668325

    Thanks Sunil.

    That looks quite a handy and easy approach. I will definitely give it a try.

    However, as of now I am using a different approach of triggering the Subscription IDs through Batch files (using execute process task) and that is also serving my purpose of generating the SSRS reports through SSIS.

    Thanks again.

    Regards,

    Prasune Verma

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply