If you need to copy or move SSRS reports between servers there is a great, free utility called Reporting Services Scripter. It allows you automate the deployment of SSRS reports, grab RDL files off of an existing server, including the datasource and directory structure, and transfer the reports to a new server. All of this without requiring BIDS or Visual Studio.
This tip was courtesy of Dwight Specht. Feel free to tell him that he rocks.
Originally Posted by Mark Polino at 10/04/2010 09:00:00 AM