How can you send a SSRS report from SSIS?

1.	How can you send a SSRS report from SSIS?
Answer» After an SSIS package has completed a data load, it is frequently NECESSARY to be able to transmit an SSRS report in Excel, PDF, or another format to different users. To begin, you MUST first create a subscription to the report. From the Report Manager, you can create an SSRS report subscription. You can specify the report format and the recipient's EMAIL address when subscribing to a report. A SQL SERVER Agent Job is established when you set a schedule for an SSRS report. You may run the SSRS report subscription from SSIS by using sp_start_job and giving the required job name.

Discussion