CODEWITHSUNDEEP
reporting-servicesbusiness-intelligencesubscription
Powell
Powell

Reputation: 157

SSRS Subscription Failure

This is hopefully a simple yes/no question but I cant find anything definitive online.

If an SSRS subscription - on a once a day schedule - fails because a data source is deleted, if you rebuild the data source will the subscription run as normal the following day or do you need to alter the subscription to rebuild it?

Thanks in advance

Upvotes: 0

Views: 142

Answers (2)

Sébastien Sevrin
Sébastien Sevrin

Reputation: 5405

if you rebuild the data source will the subscription run as normal the following day or do you need to alter the subscription to rebuild it?

Short answers: No and No

First No

If the datasource has been deleted and you recreate it, then the DataSourceID property will be different.

So all the dependent items will have first to be "re-linked" to the datasource (reports, shared datasets).

Second No

Nothing will have to be changed in the Subscription though, because the Subscription is linked to a Report (or Linked Report), so once everything else is valid it will run as normal.

Upvotes: 2

Mike
Mike

Reputation: 550

Assuming you are using a regular subscription and not a data driven subscription, as long as the published report's data source is set after the new data source was re-created. The subscription should work.

Upvotes: 2

Related Questions