December 1, 2008 at 8:06 am
Hi,
I have a SQL Reporting Services report that produces different output based on the customer ID. I have a query that returns the Email address and CustomerID for each subscriber. I would like to use the output of that query to drive SSRS to produce and email the report dynamically.
I could not find a way to automate this with Integration Services and I don't think generating a row in the Subscription table is viable (or is it?). I don't want to break out VB.NET if I can help it cuz I would like the solution to remain within SQL.
Any tips will be greatly appreciated.
December 1, 2008 at 10:42 am
If you are running Enterprise Edition of Reporting Services, this is exactly what data-driven subscriptions do.
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply