June 29, 2016 at 9:20 pm
Comments posted to this topic are about the item Execute a data-driven SSRS subscription from SSIS to archive a report
June 29, 2016 at 9:21 pm
Thanks for your detailed explanation. I would just caution that a republish of a report can break all of the parameter bindings in a scheduled report. Perhaps it's been improved in more recent versions but it was a real headache for us
June 30, 2016 at 12:10 am
Interesting topic, however I believe not everyone can use the "New Data-driven Subscription" link as it is only supported by SQL Server Enterprise edition?
June 30, 2016 at 5:23 am
Probably worth considering not hardcoding the SubId into the package either, but rather using the DDS name/description:
SELECT @SubId=SubscriptionID FROM dbo.Subscriptions WHERE Description='DDS_Name'
EXEC dbo.AddEvent @EventType = N'TimedSubscription', , @EventData = @SubId
June 30, 2016 at 6:15 am
nick.mcdermaid (6/29/2016)
Thanks for your detailed explanation. I would just caution that a republish of a report can break all of the parameter bindings in a scheduled report. Perhaps it's been improved in more recent versions but it was a real headache for us
Couldn't you just create a separate subscription from the actual scheduled subscription?
June 30, 2016 at 12:20 pm
Any way to get this to work with a report in a load balanced sharepoint system instead of SSRS
Viewing 6 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy