SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


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


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

Author
Message
Prasune Verma
Prasune Verma
Valued Member
Valued Member (56 reputation)Valued Member (56 reputation)Valued Member (56 reputation)Valued Member (56 reputation)Valued Member (56 reputation)Valued Member (56 reputation)Valued Member (56 reputation)Valued Member (56 reputation)

Group: General Forum Members
Points: 56 Visits: 82
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
eric.muller
eric.muller
SSC Eights!
SSC Eights! (838 reputation)SSC Eights! (838 reputation)SSC Eights! (838 reputation)SSC Eights! (838 reputation)SSC Eights! (838 reputation)SSC Eights! (838 reputation)SSC Eights! (838 reputation)SSC Eights! (838 reputation)

Group: General Forum Members
Points: 838 Visits: 1373
Barring a TSQL solution, I have done this in the past with a scripting object that calls to the report server via URL.

THIS 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
sunilreddy
sunilreddy
SSC Journeyman
SSC Journeyman (99 reputation)SSC Journeyman (99 reputation)SSC Journeyman (99 reputation)SSC Journeyman (99 reputation)SSC Journeyman (99 reputation)SSC Journeyman (99 reputation)SSC Journeyman (99 reputation)SSC Journeyman (99 reputation)

Group: General Forum Members
Points: 99 Visits: 381
Hi, Thanks for sharing my post, I have also explained another possible approach. Please go through it and let me know your comments.

[url=http://msbimentalist.wordpress.com/2013/10/16/execute-ssrs-report-from-ssis-package-part2/][/url]

Thanks

sunilreddy
http://msbimentalist.wordpress.com :-)
Prasune Verma
Prasune Verma
Valued Member
Valued Member (56 reputation)Valued Member (56 reputation)Valued Member (56 reputation)Valued Member (56 reputation)Valued Member (56 reputation)Valued Member (56 reputation)Valued Member (56 reputation)Valued Member (56 reputation)

Group: General Forum Members
Points: 56 Visits: 82
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
Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum

































































































































































SQLServerCentral


Search