March 16, 2012 at 12:32 pm
I just recently learned how to use Foreach Loop Container to email Excel files to a list of users dynamically created from a table (http://www.sqlservercentral.com/Forums/Topic1225941-145-1.aspx).
Is there something similar in the Server Reporting Services? Or how would one run the same report several times, and email it to different addresses?
Any input would be greatly appreciated.
March 16, 2012 at 12:37 pm
Create different subscriptions for each email address.
http://technet.microsoft.com/en-us/sqlserver/Video/dd420576
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
March 19, 2012 at 1:24 pm
Thank you, SQLRNNR! 🙂
Apparently, we are running the Standard version of SQL 2005 server, which doesn’t support Data driven subscriptions .. What a joy!
Viewing 3 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply