Refersh SSRS snapshot using t-SQL command

• manjunath.venkatesh

  Grasshopper

  Points: 16

  More actions

  September 18, 2014 at 1:47 am

  #299452

  Topic : Refersh SSRS snapshot from an external SSIS pacakge

  Issue

  A report is created with data driven subscription. Since there is no specific schedule to refresh the snapshot, this event should be automated.

  Therefore snapshot needs to be refreshed from an external SSIS package using a t-SQL command.

  I have used below command in a SSIS package (Execute SQL task) but is not refreshing as expected …

  exec [ReportingService].dbo.AddEvent @EventType='ReportExecutionUpdateSchedule', @EventData= 'ReportID'

  Please advise.