October 25, 2016 at 10:37 am
I have the following 2 questions to ask about a SSRS 2012 data driven subscription:
1. On a test report server, I am testing the data driven subscription that I have setup. Everyone time I want to change some value, I hit the edit option and almost everything that was entered previously is lost. Thus is there a way to save what was previously entered? If so, how would I save the values and update them when I need to?
2. The ssrs data driven subscription information is saved in the database somewhere. Can you tell me where this information is saved and how to access this information? I want to be able to save this information in TFS (version control software) if possible.
October 27, 2016 at 5:44 pm
dianerstein 8713 (10/25/2016)
I have the following 2 questions to ask about a SSRS 2012 data driven subscription:1. On a test report server, I am testing the data driven subscription that I have setup. Everyone time I want to change some value, I hit the edit option and almost everything that was entered previously is lost. Thus is there a way to save what was previously entered? If so, how would I save the values and update them when I need to?
I haven't seen this behavior, other than passwords blanking out and having to be re-entered.
2. The ssrs data driven subscription information is saved in the database somewhere. Can you tell me where this information is saved and how to access this information? I want to be able to save this information in TFS (version control software) if possible.
Subscription info lives in the ReportServer database. Here's a generic query to get you started on the data-driven subscriptions:
USE ReportServer
SELECT c.Name AS Report
, s.Description
,*
FROM dbo.SubscriptionsAS s
INNER JOIN dbo.CatalogAS cON s.Report_OID = c.ItemID
INNER JOIN dbo.ReportScheduleAS RSON S.SubscriptionID = RS.SubscriptionID
INNER JOIN dbo.ScheduleAS ScON RS.ScheduleID = Sc.ScheduleID
WHERE s.DataSettings IS NOT NULL--for data-driven
October 31, 2016 at 2:31 pm
Is the report server database stored only on the report server? Can it be accessed by ssis manager 2012? If so, how do you access the report server database on ssis manager 2012? If ssis 2012 can not access the reportserver database, would you show me how the report server database can be accessed?
October 31, 2016 at 3:54 pm
dianerstein 8713 (10/31/2016)
Is the report server database stored only on the report server? Can it be accessed by ssis manager 2012? If so, how do you access the report server database on ssis manager 2012? If ssis 2012 can not access the reportserver database, would you show me how the report server database can be accessed?
Yes, the ReportServer database lives on whichever server SSRS is installed on. I'm not familiar with SSIS, but via SSMS it's no different than any other SQL DB connection. With the "Use ReportServer" at the begin of the query, as long as you're on the right server it should work. One sticking point might be ensuring you have permissions to query the ReportServer DB.
November 1, 2016 at 2:59 am
What were you thinking of using SSIS for?
You could also take a look at the table ExecutionLogStorage in the ReportServer database
This holds a log of reports run along with criteria
- Damian
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply