Home Forums Reporting Services Reporting Services Report Subscription - Send email after saving to windows share RE: Report Subscription - Send email after saving to windows share

  • August 27, 2013 at 12:15 pm

    #1645301

    kk1173 (8/26/2013)

    I have a SSRS data subscription that saves a file to windows share. The report runs monthly.

    There is a new requirement now that after the file gets saved to the windows share, an email needs to be generated to users mentioning that the file is available at the windows shared location.

    Please help if this is possible. I only see either windows file or email option in SSRS.

    Would it be possible to run the report from SSIS and then use SSIS' Send Mail task to email that it is completed? You could create a SQL Agent job and schedule it to run monthly.

    There's an article here on SSC: http://www.sqlservercentral.com/articles/Integration+Services+(SSIS)/93504/

    HTH,

    Rob