Post reply

Report Subscriptions from Configuration Table

  • February 10, 2016 at 3:12 am

    #324169

    Hi

    I have a report that needs to be sent to a number of people all with differing parameter entries in.

    Is there a way of administering this in a configuration table?

    Thanks

  • February 10, 2016 at 3:52 am

    #1857624

    Are you on Enterprise Edition? If so this would be a job for Data Driven subscriptions.

  • February 10, 2016 at 4:22 am

    #1857632

    On standard version you can create procedure with coursor and update data (set parameters) and run subscriptions

  • February 10, 2016 at 4:50 am

    #1857640

    thanks for the replies

    I have built a ssis package with a for each loop from a result set

    all working swimmingly

    thanks again

Viewing 4 posts - 1 through 3 (of 3 total)

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