Calling RS through DTS

Does anyone have an example? Can this be done through VBS?
I need to do some preprocessing and then render a report.
ThanksIs the environment all SQL Server? Your report could actually call a
stored procedure which kicks off DTS and then returns data when the DTS
is done.
Andy Potter|||We use shared schedules on subscriptions. This gives us the ability to look
up the shared schedule's Name in the Schedule table to find the ScheduleID.
One you have the ScheduleID you can run the subscription via the AddEvent SP.
You can lookup how to do this in the SQL Server Agent, but it is simple:
exec ReportServer.dbo.AddEvent @.EventType='SharedSchedule',
@.EventData='57a5c647-81bb-4715-be5c-7297dd7c306f'
you just need to put the ScheduleID in the @.EventData section. We actually
run this from Services for UNIX using isql, but I know this can be done
similarly from DTS.
The other nice thing about shared schedules is that you can put multiple
subscriptions on a single shared schedule and kick them all off at once.
We set all of our shared schedules that we use this way to run once in the
past so they never run other than when we trigger them.
Hope this helps!
"CatsCradle" wrote:
> Does anyone have an example? Can this be done through VBS?
> I need to do some preprocessing and then render a report.
> Thanks
>