LoadReport() exception in SSIS script task
All, I'm running into any exception when I call LoadReport() in an integrated mode SharePoint 2010/SQL 08R2 setup. The code is fairly straight-forward I think, and so it's not apparent what is causing the exception. I am executing this code within an SSIS script task. I've created the proxy code using the following: wsdl.exe /language:CS /out:ReportServiceExecution.cs http://[ReportServerName]/ReportServer/ReportService.asmx?WSDL Now the code that I am running looks like the following, and the line is excepting on LoadReport() and throwing the following error. ReportExecutionService rsExec; rsExec = new ReportExecutionService(); rsExec.Timeout = (int)new TimeSpan(1, 0, 0).TotalMilliseconds; ExecutionInfo execInfo = new ExecutionInfo(); ExecutionHeader execHeader = new ExecutionHeader(); rsExec.ExecutionHeaderValue = execHeader; rsExec.Credentials = System.Net.CredentialCache.DefaultCredentials; rsExec.Url = "http://apse9938:80/RAAREPORTSERVER/wsReportExecution2005.asmx"; string historyID = null; string _reportName = @"http://apsw8378/Reports/CAMS%20Employer%20Reports/Utilization%20Report.rdl"; string _historyID = null; try { ExecutionInfo ei = rsExec.LoadReport(_reportName, historyID); Dts.TaskResult = (int)ScriptResults.Success; } catch (Exception ex) { Dts.TaskResult = (int)ScriptResults.Failure; throw ex; } Exception thrown: InvalidOperationException: Client found response content type of '', but expected 'text/xml'.\r\nThe request failed with an empty response." Any thoughts on what might be going wrong here would be greatly appreciated. Thanks!
December 10th, 2010 12:21pm

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics