Home Forums Reporting Services SSRS 2012 Export Report to SSMS RE: Export Report to SSMS
sql Sarah
SSCrazy
Points: 2081
More actions
July 9, 2014 at 10:06 am
#1728133
I would suggest using SSIS for this.
First create a subscription for the report that writes the data to a text or csv file.
Create an SSIS package to read the file and import it into the table.