July 9, 2012 at 1:36 pm
Hello,
Is there any possibility to have dynamic sender/from addresses in SSRS subscriptions? For example I need to use "HumanResource@organization.com" for some set of subscriptions and "AccountsPayable@organization.com" for other set of subscriptions as sender. Thanks for looking into this.
Sri
July 10, 2012 at 7:45 am
Don't quote me but I believe that this would require a dynamic config file change, and probably a service restart. I think it is possible, but difficult and very impractical.
July 10, 2012 at 7:59 am
If you roll your own subscription service using SSIS to access your SSRS reports and send the email via T-SQL or SSIS component you can specify which mail profile to use. I think these articles shoudld get you started: http://msdn.microsoft.com/en-us/library/ff793463.aspx and http://vsteamsystemcentral.com/cs21/blogs/steve_fibich/archive/2009/04/27/ssis-and-reporting-services-web-services.aspx.
MWise
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply