Search code examples
sql-serverxmlssisetlssis-2008

SSIS Web Service Task returns a file file with "<", </Value> characters


I have a simple ssis package what saves result from web service method to XML file. Connection OK, file creating, but contains &lt; and &gt; tags instead of < and > .

How I can replace this tags to correct? enter image description here


Solution

  • The main issue is that you are passing the xml from the web service as a string (Not recommended)

    you have to change the web method to return an XmlDocument, load the well-formed xml into it, and passed it back SSIS.

    Or you can do a little workaround is to run a script after saving the xml file and replace &lt; with < and &gt; with >

    Useful Links