This is a requirement when you need to send a SSRS report in Excel, PDF format to different users from SSIS after performing a data load.
First you need to create 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, 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.
No comments:
Post a Comment