How to send a SSRS report from SSIS?

Next>>         SQL Server tutorial  

SQL Server - how to send a SSRS report from SSIS? - Feb 27, 2010 at 11:50 AM by Shuchi Gauri

How to send a SSRS report from SSIS?

Steps to send a SSRS report from SSIS:

• Create a subscription to the report from Report Manager.
• At subscription level, mention the report format and email address of the recipient user. When a schedule is created for SSRS report, an SQL Server agent job is created.
• Execute the SSRS report subscription using sp_start_job with the appropriate report name.

SQL Server - how to send a SSRS report from SSIS? - May 05, 2009 at 22:00 PM by Rajmeet Ghai

How to send a SSRS report from SSIS?

SSIS has the ability to send SSRS report in different formats like Excel, PDF etc. This is achieved by creating a report subscription using the Report manager. In the report subscription, the format of the SSRS report can be mentioned along with the email address of the recipient. sp_start_job is used to execute the report subscription.

SQL Server - how to send a SSRS report from SSIS? - June 21, 2009 at 09:00 PM by Amit Satpute

After the SSIS package has finished loading the data, the SSRS report can be sent to different users in .xls, .pdf, etc formats.

The steps one needs to follow to do this are:

• Creation of an SSRS report subscription from Report Manager.
• Entering the report format and the email address of the recipient in the subscription.
• Creation of a schedule for the SSRS report so that the SQL Server Agent Job gets created.
• Execution of SSRS report subscription from the SSIS by using sp_start_job and providing a relevant job name.

Next>>

Also read

SQL Server Reporting Services

What can SQL Server Reporting Services do? Explain the architecture of reporting services. Describe Reporting Lifecycle. What are the ways to tune Reporting Services?......

How to schedule SSAS Database backup.

SSAS database backups can be taken using SQL Server Management Studio (SSMS)......

How to Generate an Auto Incremental Number in a SSIS Package?

Auto incremental numbers in a SSIS package can be provided using script components...........

Lookup's are a key component in SQL Server Integration Services (SSIS). Explain its purpose

Lookup transformation combines data from two sources. The fields of these sources are matched......

How to unzip a File in SSIS?

Execute Process Task in the Control Flow task can be used to unzip a file......