Post reply

Call SSRS report from ssis

  • November 15, 2010 at 7:48 am

    #149313

    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,

  • November 15, 2010 at 9:31 am

    #1250819

    Please help.

  • November 18, 2010 at 1:10 pm

    #1252718

    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/

  • May 17, 2013 at 11:50 am

    #1616305

    I am also looking for the same...Please Help..

    I dont understand that website ...can anyone guide?

  • May 20, 2013 at 3:37 am

    #1616555

    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

    You can lead a horse to water, but a pencil must be lead.
    Stan Laurel

  • August 4, 2015 at 1:31 am

    #1817012

    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]

    SSIS Json source[/url] : The Json file soure is used to to read data from Json file. We have mentioned source code with example.

  • December 19, 2015 at 4:32 am

    #1846917

    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/

    🙂

    SSIS Json source[/url] : The Json file soure is used to to read data from Json file. We have mentioned source code with example.

Viewing 7 posts - 1 through 6 (of 6 total)

You must be logged in to reply to this topic. Login to reply