asked
How to pass in xmlNode into SSIS Web Service Task input with variable
I've created a web service task and downloaded the provided wsdl document. You can see the input parameters for the given called method below: ![alt text][1] According to an example in the API, I'm supposed to pass in this xml: 01/01/2000 I've tried creating a string value and using this XML (see screenshot), but I can't get the method to execute. The call does work with SOAPUI, but I really need to get this call working with SSIS. I've tried passing any so many variations of the XML to get the call to work, but haven't had any success. Is there a special way to pass in an xml node as a parameter with SSIS? ![alt text][2] [1]: /storage/temp/2370-input.png [2]: /storage/temp/2371-variable.png
My personal experience with the Web Service task has proven it to be buggy and unstable. I would recommend that you use a script task and write .NET code to connect to the web service, pass the necessary information and extract the data you need.
19 People are following this question.
