SSRS Changing Output Location to a different location

• ericwenger1

  Hall of Fame

  Points: 3436

  More actions

  January 18, 2022 at 9:46 pm

  #3974381

  We are in the process of migrating a customer to our environment. This customer has a lot of SSRS Subscriptions that are writing out to a file share on a particular server. Is there a way to do a mass change so that the location can be changed to our Server's file share without having to go through each SSRS Subscription and make these changes?

   

  Thanks in advance

• Michael L John

  One Orange Chip

  Points: 27055

  More actions

  January 19, 2022 at 8:06 pm

  #3974929

  I'm taking a guess here.

  Query the Subscriptions table in the SSRS database.  In the ExtensionSettings column is the XML that might store the path.

  Update the column to the new path.   See what happens!

   

  I may try this with a bogus subscription before you update everything!

  Michael L John
  If you assassinate a DBA, would you pull a trigger?
  To properly post on a forum:
  http://www.sqlservercentral.com/articles/61537/