Post reply

Execute a data-driven SSRS subscription from SSIS to archive a report

  • June 29, 2016 at 9:20 pm

    #400341

    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

    #1887766

    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

    #1887779

    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

    #1887823

    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

    #1887836

    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

    #1887947

    Any way to get this to work with a report in a load balanced sharepoint system instead of SSRS

Viewing 6 posts - 1 through 5 (of 5 total)

You must be logged in to reply to this topic. Login to reply