Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

ReportServer.dbo.AddEvent stored proc on dbo.Event table not feasible to trigger SSRS through SSIS Expand / Collapse
Author
Message
Posted Wednesday, August 14, 2013 1:22 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Friday, July 18, 2014 1:33 AM
Points: 19, Visits: 45
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
Post #1484097
Posted Thursday, August 15, 2013 11:19 AM
Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Wednesday, October 15, 2014 9:54 AM
Points: 312, Visits: 855
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
Post #1484855
Posted Thursday, November 21, 2013 9:46 PM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Friday, September 12, 2014 3:51 AM
Points: 19, 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
Post #1516638
Posted Friday, November 22, 2013 2:39 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Friday, July 18, 2014 1:33 AM
Points: 19, Visits: 45
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
Post #1516691
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse