can I call the wcf web service from webservice task SSIS package?

• m_rajib74

  Old Hand

  Points: 301

  More actions

  March 23, 2010 at 12:32 pm

  #222181

  I have created one webmethod in wcf service.It takes an input parameter (datatype integer).while calling the wcf service from web service task it giges following 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: Method 'ProxyNamespace.Service1.GetData' not found..   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)   at Microsoft.SqlServer.Dts.Tasks.WebServiceTask.WebServiceTask.executeThread()".

• Santiago Perez

  SSC-Addicted

  Points: 498

  More actions

  December 15, 2010 at 10:25 am

  #1263010

  I'm encountering this error at the moment. Did you ever find a solution to your problem?