Hi,

Ihave created a SSIS package with Web Service task in it,which execute remote server web service

I got following error during Web service execution

Note:I am not using proxy settings,i also checked HTTP connection and it suceeded

Error:[Web Service Task] Error: An error occurred with the following error message: "Microsoft.SqlServer.Dts.Tasks.WebServiceTask.WebserviceTaskException: Could not execute the Web method. The error is: Object reference not set to an instance of an object.. at Microsoft.SqlServer.Dts.Tasks.WebServiceTask.WebMethodInvokerProxy.InvokeMethod(DTSWebMethodInfo methodInfo, String serviceName, Object connection) at Microsoft.SqlServer.Dts.Tasks.WebServiceTask.WebServiceTaskUtil.Invoke(DTSWebMethodInfo methodInfo, String serviceName, Object connection, VariableDispenser taskVariableDispenser) at Microsoft.SqlServer.Dts.Tasks.WebServiceTask.WebServiceTask.executeThread()".

Please help..

Thanks in advance

But do you need to use a proxy?

Have you read through this thread? http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=500619&SiteID=1

Yes,I read that thread,

I am using web service from LAN,so I can bypass proxy and I can connect to web service without proxy

HTTP connection succeeeded without proxy.

any other suggetions.

Hi,

Any idea ?

Hi,

Was your issue resolved? How did you resolve it?

Thanks.