Home Forums SQL Server 2005 SQL Server 2005 Integration Services Call SSRS report from ssis RE: Call SSRS report from ssis

  • 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/