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