locked
web service method could not execute web method gives error RRS feed

  • Question

  • Hello

    I'm getting error in web service task.

    [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()".

    May be it is because of Proxy .

    kindly help me to resolve this issue.

    Wednesday, February 13, 2013 5:35 AM

Answers

  • I would try to connect to the webservice using a swiftly crafted Console Application in which a debugger would catch the row where the error occurs.

    I trust it is simply a security issue but could be a connection to the webservices.

    If you do not code, try webservices tester tools, like SOAPUI or any other. Lastly you can try accessing the webservice using EI by navigating to its asmx address.

    Tell us what you find.


    Arthur My Blog

    • Proposed as answer by jonfaulkenberry Wednesday, February 13, 2013 5:07 PM
    • Marked as answer by Eileen Zhao Monday, February 25, 2013 2:11 AM
    Wednesday, February 13, 2013 2:52 PM