Reputation: 13
Is there a way to create a copy of an existing report (that is already deployed to the report server) using a SQL script? We are using SSRS 2008 R2. Thank you in advance for any help!
Possibly copying the record from the Catalog table??
Upvotes: 1
Views: 127
Reputation: 2156
Don't think so using SQL Script.
If you are using SSIS, then it can be done by using a HTTP Connection (report server URL, where the existing report is deployed) and a script task (To download to the local system).
Upvotes: 1