The problem is that the SSIS Web Service Task does not handle namespaces other than the default.
While the web service WSDL file may validate just fine, SSIS still balks at it. Here’s how to fix up the WSDL file.
Before:
<wsdl:definitions ... targetNamespace="http://tempuri.org" xmlns:tns="http://tempuri.org" xmlns:ns1="http://www.MyServiceTargetNameSpace.com"> ... <wsdl:service name="MyServiceName"> <wsdl:port name="MyPortName" binding="ns1:MyBindingName"> ... </wsdl:port> </wsdl:service> </wsdl:definitions>
After:
<wsdl:definitions ... targetNamespace="http://www.MyServiceTargetNameSpace.com" xmlns:tns="http://www.MyServiceTargetNameSpace.com"> ... <wsdl:service name="MyServiceName"> <wsdl:port name="MyPortName" binding="tns:MyBindingName"> ... </wsdl:port> </wsdl:service> </wsdl:definitions>
You could also just overwrite the targetNamespace and xmlns:tns attribute values with your service target namespace. Essentially, they all have to end up being the same namespace for it to work.