Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Call SSRS report from ssis Expand / Collapse
Author
Message
Posted Monday, November 15, 2010 7:48 AM
Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Thursday, July 16, 2015 9:42 AM
Points: 343, Visits: 1,173
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,
Post #1020787
Posted Monday, November 15, 2010 9:31 AM
Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Thursday, July 16, 2015 9:42 AM
Points: 343, Visits: 1,173
Please help.
Post #1020881
Posted Thursday, November 18, 2010 1:10 PM


Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Friday, April 24, 2015 5:10 AM
Points: 1,118, Visits: 2,233
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/

Post #1023131
Posted Friday, May 17, 2013 11:50 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Wednesday, October 16, 2013 8:31 PM
Points: 18, Visits: 117
I am also looking for the same...Please Help..

I dont understand that website ...can anyone guide?
Post #1454147
Posted Monday, May 20, 2013 3:37 AM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Today @ 6:08 AM
Points: 5,977, Visits: 14,423
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.



Help us to help you. For better, quicker and more-focused answers to your questions, consider following the advice in this link.

When you ask a question (and please do ask a question: "My T-SQL does not work" just doesn't cut it), please provide enough information for us to understand its context.

I had some words with my wife, and she had some paragraphs with me.
Post #1454459
Posted Today @ 1:31 AM


Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Today @ 1:32 AM
Points: 2, Visits: 17
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.



SSIS Json source : The Json file soure is used to to read data from Json file. We have mentioned source code with example.
Post #1708161
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse