locked
XML source and merge join RRS feed

  • Question

  • Hi Team,

    I have issue reading fields from  the xml file

    i tried the blog:http://blogs.msdn.com/b/mattm/archive/2007/12/11/using-xml-source.aspx

    but my xml file has lot of nodes:

     

    <?xml version="1.0" encoding="utf-8"?>

    <enrolment>

    <date>2011-01-28T17:51:36.6562500Z</date>

    <account>

    <name>account</name>

    <value>5750</value>

    </account>

    <context>

    <name>Accounty</name>

    <value>NS Organization</value>

    <product>

    <name>product</name>

    <value>G131990 AD  D</value>

    </product>

    <policynumber>

    <name>policynumber</name>

    <value>G131990</value>

    </policynumber>

    </context>

    <enrolment>

    and merge join will accept two joins only please tel me which one join?

     

    Thanks,

    Eshwar

    Thursday, February 3, 2011 9:09 AM

Answers

  • Why the <enrolment> element at the end does not have </enrolment>?

    To me looks like you are getting too many columns in the source, the issue can be solved by surrounding you XML with an outer element and then you will get a single set.

    Example to what I mean:

    <?xml version="1.0" encoding="utf-8"?>

    <ENROLLMENTDATA>

    <enrolment>

    <date>2011-01-28T17:51:36.6562500Z</date>

    <account>

    <name>account</name>

    ... etc

    <enrolment>

    </ENROLLMENTDATA>

     


    Arthur My Blog
    By: TwitterButtons.com
    • Proposed as answer by Jerry Nee Friday, February 4, 2011 9:57 AM
    • Marked as answer by Jerry Nee Tuesday, February 15, 2011 3:01 AM
    Thursday, February 3, 2011 2:39 PM

All replies

  • Why the <enrolment> element at the end does not have </enrolment>?

    To me looks like you are getting too many columns in the source, the issue can be solved by surrounding you XML with an outer element and then you will get a single set.

    Example to what I mean:

    <?xml version="1.0" encoding="utf-8"?>

    <ENROLLMENTDATA>

    <enrolment>

    <date>2011-01-28T17:51:36.6562500Z</date>

    <account>

    <name>account</name>

    ... etc

    <enrolment>

    </ENROLLMENTDATA>

     


    Arthur My Blog
    By: TwitterButtons.com
    • Proposed as answer by Jerry Nee Friday, February 4, 2011 9:57 AM
    • Marked as answer by Jerry Nee Tuesday, February 15, 2011 3:01 AM
    Thursday, February 3, 2011 2:39 PM
  • It is hard to say which ones to join if we don't know what you want out of the source.  What does one row look like?  What do you want to output?


    Russel Loski, MCT
    Thursday, February 3, 2011 2:53 PM