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.
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,