Email reports from SSRS to users via SSIS

• samalex

  SSCertifiable

  Points: 5428

  More actions

  December 18, 2008 at 2:25 pm

  #125286

  Hi,

  We have a number of reports created in SQL Server Reporting Services, and I'd like to email them to users each night via an SSIS package. I'm trying to find how to download the reports in either pdf or excel format then email them to users, but I can't find a simple way of doing this.

  Any suggestions?

  Thanks,

  Sam Alex

• Mukti

  SSCrazy

  Points: 2746

  More actions

  December 18, 2008 at 6:29 pm

  #914944

  I am not sure why you wanna use SSIS when Reporting Services can do this via Subscriptions?

  Reporting Services Subscriptions will allow you to send the report in any format HTML/EXCEL/PDF and you can schedule it to run nightly.

  http://msdn.microsoft.com/en-us/library/ms160334.aspx

  HTH