locked
Extracting data from XML RRS feed

  • Question

  • Hello,
    I have an SSIS package that queries a web service to return the XML data. The XML returned has &lt; instead of < &gt; instead of >.
    How can I transform it from string back to XML to extract the data?

    Thanks,
    Sunday, January 3, 2010 1:42 PM

Answers

  • Hello,
    I have an SSIS package that queries a web service to return the XML data. The XML returned has &lt; instead of < &gt; instead of >.
    How can I transform it from string back to XML to extract the data?

    Thanks,
    You can use script. Check HttpUtility.HtmlDecode method.

    SSIS Tasks Components Scripts Services | http://www.cozyroc.com/
    • Marked as answer by Zongqing Li Friday, January 8, 2010 9:52 AM
    Sunday, January 3, 2010 2:58 PM