SteveD SQL (10/6/2016)
My SSIS solutions works just fine, though I am sure some SSIS developers would have a fit me using SSIS as a Report Distribution System 😉Thanks
Steve
I do the same thing with repeating subscriptions. Inside a For Loop, I use a SQl Task to amend the XML, then do the subscription, then check if the subscription has finished (if not loop a wait timer till it has or a certain time has passed), and then do the next one.
it's "ugly" but it works 🙂
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk