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.

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

I am trying to use RS Scripter to generate deployment scripts for SSRS 2008 R2 but it doesn't script out the shared datasets and any linked reports. I am using the label: SQL Server 2008 and it uses http://localhost/ReportServer/ReportService2005.asmx I have tried various options and even though the RS Scripter says it can script out linked reports I am unable to script them. I can only see two options related to linked reports in the tool - a. OverwriteLinkedReport b. TransferLinkedReportSize Both these options are set to true. I am using 2.0.0.17 version of RS Scripter. The only option that seems to work for shared datasets is to use http://localhost/ReportServer/ReportService2010.asmx and programatically add the shared datasets to the report server. But this is very time consuming as I have too many objects that I have to deploy. I will really appreciate any help/suggestion. Thanks, Sugandha