Scripting subscription from Reporting Services 2005
How do I script a subscription in SSRS 2005?I am required to create about 100 subscriptions with different values passing to the parameter.I am looking for a easy way where I create a subscription manually and then script it and then execute them with different parameter values for about 100 times to create the new subscriptions.Thanks in advance.
February 11th, 2010 4:59pm
If you can't use SOAP API CreateSubscription, then seems like RS Scripter could help: http://www.sqldbatips.com/showarticle.asp?ID=62At least it claims to allow "Generate Scripts for Normal and Data Driven Report Subscriptions". IgorThis posting is provided "AS IS" with no warranties, and confers no rights.
February 11th, 2010 9:58pm
Thank you very much. Actually Figured out a way to script subscriptions from the microsoft site only.
February 11th, 2010 10:28pm
Hi venk_r,Based on your description, I am sure Data-Driven subscription is appropriate for you.However, Data-Driven subscription is only available in Enterprise edition. If you are not using Enterprise edition, you may try this:http://social.msdn.microsoft.com/Forums/en-US/sqlreportingservices/thread/90e54600-4479-4cf0-8ae4-0e3588ee34b2For more information about Data-Driven subscription, please see:http://msdn.microsoft.com/en-us/library/ms159150.aspxBy the way, if you have found the answer, could you please post it in this thread? This will benefit other community members who meet the same issue.Thanks,Jin ChenJin Chen - MSFT
February 16th, 2010 12:30pm
venk_r, it would be nice to have the reference to the document you refer to. I for one would appreciate know how to do it as well. Thanks
January 15th, 2011 7:44am