Reporting Services Automated Scripter
Download Reporting Services Scripter
In class this week, one of the students told me about an automated scriptor for SQL Server 2000 Reporting Services. So I checked it out and wanted to pass it along to anyone actually reading this blog.
If you go to the link above, it will take you to a website describing the RSScriptor program. It's a .NET program that connects to your Reporting Services server and gives you an MMC view of all your Reporting Services objects. You can then select the objects, specify what you want to script in the Options section and it will generate .RSS scripts that use the RS.EXE program. It also generates a .CMD file that executes RS.EXE with the proper parameters.
This tool can make it easier to move reports, datasources, and resources from a development server to production. And the best part is that it builds and underlying script that can be reexecuted multiple times.
It's also a great way to learn how to code some of the Reporting Services web service methods.
Thank you DK for the reference.
In class this week, one of the students told me about an automated scriptor for SQL Server 2000 Reporting Services. So I checked it out and wanted to pass it along to anyone actually reading this blog.
If you go to the link above, it will take you to a website describing the RSScriptor program. It's a .NET program that connects to your Reporting Services server and gives you an MMC view of all your Reporting Services objects. You can then select the objects, specify what you want to script in the Options section and it will generate .RSS scripts that use the RS.EXE program. It also generates a .CMD file that executes RS.EXE with the proper parameters.
This tool can make it easier to move reports, datasources, and resources from a development server to production. And the best part is that it builds and underlying script that can be reexecuted multiple times.
It's also a great way to learn how to code some of the Reporting Services web service methods.
Thank you DK for the reference.
Jeff Jones
Post a Comment
View Printer Friendly Version
Email Article to Friend
Reader Comments