March 17, 2009 at 6:03 pm
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.
March 18, 2009 at 7:07 am
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.
Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question
March 18, 2009 at 8:10 am
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