I just searched forum and cannot find what I need. From web site for web service calling from SSIS step by step, I setup http connection, and download WSDL file with no problem. I then go to input part to select service and method. After method chosen, I
can see 3 parameter variables as all string type. They told me that 1 variable is input string, the other variables are output strings.
The main task is to use web service to call the method to pass XML file. I want to know should I create 3 project level variables to hold as corresponding 3 parameter variables? Does it mean that I should copy all XML file content to input parameter variable?
How can I see the ouptut value of parameter variables?
For output part, I created new file as output.xml file. After package run, it shows me "<Result>The
result is null. Either the result is null or the Web method returns void.</Result> ". What
does this mean?
Thanks for any info or help!
View Complete Post