How to send a SSRS report from SSIS?
Often there is a requirement to be able to send a SSRS report in Excel, PDF or another format to different users from a SSIS package one it has finished performing a data load.
In order to do this, first you need to create a subscription to the report. You can create a SSRS report subscription from Report Manager. At the report subscription you can mention the report format and the email address of the recipient. When you create a schedule for the SSRS report, a SQL Server Agent Job will be created.
From the SSIS, by using sp_start_job and passing the relevant job name you can execute the SSRS report subscription.
In order to do this, first you need to create a subscription to the report. You can create a SSRS report subscription from Report Manager. At the report subscription you can mention the report format and the email address of the recipient. When you create a schedule for the SSRS report, a SQL Server Agent Job will be created.
From the SSIS, by using sp_start_job and passing the relevant job name you can execute the SSRS report subscription.
What if the report is at sharepoint? The report was deployed to Sharepoint 2010 instead of Report Manager. How do I run the report from SSIS? Thanks in advance.