Call SSRS report from ssis
-
I need to call a ssrs report from SSIS using a script task that has a File_ID as a parameter from the SSIS package.
I have created the ssrs report and the ssis package. But not sure how to call the report from SSIS. Also the report needs to be stored ata particular location and from that SSIS needs to email the report to the recipients in excel format.
Thanks,
-
Please help.
-
PSB (11/15/2010)
I need to call a ssrs report from SSIS using a script task that has a File_ID as a parameter from the SSIS package.I have created the ssrs report and the ssis package. But not sure how to call the report from SSIS. Also the report needs to be stored ata particular location and from that SSIS needs to email the report to the recipients in excel format.
Thanks,
Why are you double-posting? Your question was already answered here.
---
SSIS Tasks Components Scripts Services | http://www.cozyroc.com/
-
I am also looking for the same...Please Help..
I dont understand that website ...can anyone guide?
-
shrsan (5/17/2013)
I am also looking for the same...Please Help..I dont understand that website ...can anyone guide?
Which part don't you understand?
I don't think that there is a two-minute way of doing this, if that's what you are hoping for.
The absence of evidence is not evidence of absence
- Martin Rees
The absence of consumable DDL, sample data and desired results is, however, evidence of the absence of my response
- Phil Parkin -
Hello,
I am well with ssrs from from ssis. I have already worked with this. Here I would like to mention some steps that includes that how to call SSRS report from ssis.
1.Automate reporting services report export and email process using SSIS.
2.Support for SSRS 2005/2008/2012.
3.Support for Local report which requires no connectivity to SSRS server, just provide rdl file and runtime connection to export report.
4.Support for Sharepoint Integrated Mode.
5.Export report in xls, pdf, doc, xml, mhtml and csv format
6.Send report as attachment to list of users
7.Support for Data Driver export process. You can configure reports, recipients, file format and many other options inside Database table to drive your automated export process
8.Support for SQL Server 2005, 2008, 2012, 2014 (32 bit and 64 bit).
We are having complete package of this. I think this will be helpful. More more info you can follow call ssrs from ssis.[/url]
-
Hello,
I have solution of this query, that How to Call SSRS Report from SSIS[/url] . I have complete package of this task where You will get the the sample work with source code. Package has following functionality that will be helpful for you.
1.Automate reporting services report export and email process using SSIS.
2.Support for SSRS 2005/2008/2012.
3.Support for Local report which requires no connectivity to SSRS server, just provide rdl file and runtime connection to export report.
4.Support for Sharepoint Integrated Mode.
5.You can export report in xls, pdf, doc, xml, mhtml and csv format
5.Send report as attachment to list of users
6.Support for Data Driver export process. You can configure reports, recipients, file format and many other options inside Database table to drive your automated export process
7.Support for SQL Server 2005, 2008, 2012, 2014 (32 bit and 64 bit)
To see complete detail follow this link
http://zappysys.com/products/ssis-powerpack/ssis-report-generator-task/
🙂
Viewing 7 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply