Could you please let me know how to make RS Scripter work for SSRS 2008 R2. Is there a report service 2010 for 2008 R2? <server label="SQL2008" reportservice="http://localhost/ReportServer/ReportService2010.asmx" /> Thanks

Use http://localhost/ReportServer/ReportExecution2005.asmxJeff Wharton MSysDev (C.Sturt), MDbDsgnMgt (C.Sturt) MCT, MCPD, MCITP, MCDBA Blog: Mr. Wharty's Ramblings Please mark solved if I've answered your question, vote for it as helpful to help other user's find a solution quicker

Thanks for the reply...what should the server label be? <server label="SQL2008" reportservice="http://localhost/ReportServer/ReportExecution2005.asmx" /> Regards...........

No problem. I just called mine SQL2008R2Jeff Wharton MSysDev (C.Sturt), MDbDsgnMgt (C.Sturt) MCT, MCPD, MCITP, MCDBA Blog: Mr. Wharty's Ramblings Please mark solved if I've answered your question, vote for it as helpful to help other user's find a solution quicker

Hi ione721, Just as Jeff said, you can use http://localhost/ReportServer/ReportExecution2005.asmx, for more information about it, you can refer to the following article: Report Server Web Service Endpoints: http://msdn.microsoft.com/en-us/library/ms155398.aspx Thanks, Eileen

Thanks Jeff & Eileen for your time I changed the report service but still I am only able to Deploy only the data sources(.rds) and not the reports(.rdl) files via RSScripter.exe in 2008R2 please guide me in the right direction in order to deploy 2008R2 reports via RSScripter.exe Thanks.....

btw....http://www.sqldbatips.com/showarticle.asp?ID=62 that is the link to the tool I use.

btw....http://www.sqldbatips.com/showarticle.asp?ID=62 that is the link to the tool I use.

Hi ione721, I have tried the RSScripter.exe with SQL 2008 R2 on my test environment, but the issue was not reproduced. I haven’t changed anything in RSScripter.exe, I suggest you re-download the RSScripter.exe and try again. If the issue still persists, please take the following article as a reference, Using RS Scripter to create deployment script for reporting services: http://weblogs.asp.net/akjoshi/archive/2009/01/29/using-rs-scripter-to-create-deployment-script-for-reporting-services.aspx How to automate SSRS reports deployment or How to create a setup for SSRS Reports deployment: http://siddhumehta.blogspot.com/2009/10/how-to-automate-ssrs-reports-deployment.html Just a kind reminder, I just realized that the RSScripter.exe is a third-party tool, and that you mentioned has beyond our specialty, I suggest you can contract the author via jas@sqldbatips.com. Thank for your understanding, Eileen