When I get my resulting xml from a webservice task, the response is not only well formed, but actually valid. When I put it into a string variable for passing it along to the next task in SSIS, the XPATH against it in the XML task it fails because
what happens is the XML got munged as it went into a string. All the quotes got escaped and all the linefeeds and newlines ended up as \r\n, etc.
Is there a way to avoid this or recover from this without having to save the xml to file and then load the xml from the file for the next task?
View Complete Post