How to use SSIS to execute a RS report

  • How do I use SSIS to run a report and email me the report output as either a pdf or web page? Basically I want to replicate the subscription functionality of reporting services and schedule the report to run every day using a SQL Server Agent Job.

  • As long as you either have defaults for or have a standard way to set defaults for your parameters you should be able to use a script task to generate the report and then a SendMail task to send it out. I haven't done it, but it would be an interesting experience so I may try it later today.

    Can't you use a regular subscription? You can do subscriptions with Standard Edition in 2005.

  • Yes, as Jack said, you may want to go the other direction and have the report subscription fire the SSIS package. From BOL: http://msdn.microsoft.com/en-us/library/ms345250(SQL.90).aspx

    There is an example of using SSIS to render a SSRS report to a file in Brian Knight's book "Professional SQL Server 2005 Integration Services" but it is too involved to address in this forum post - for me anyway.

Viewing 3 posts - 1 through 3 (of 3 total)

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