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.
Also read
What can SQL Server Reporting Services do? Explain the architecture of reporting
services. Describe Reporting Lifecycle. What are the ways to tune Reporting
Services?......
SSAS database backups can be taken using SQL Server Management Studio
(SSMS)......
Auto incremental numbers in a SSIS package can be provided using script
components...........
Lookup transformation combines data from two sources. The fields of these
sources are matched......
Execute Process Task in the Control Flow task can be used to unzip a file......
|
