Post reply

Load XML file to table with Parent/Child relationship

  • June 7, 2009 at 11:08 pm

    #134794

    Hi,

    I have a huge XML file having multiple output columns. I want to load all the xml values into table with relationship.

    To specify the relationship, I tried the below options.

    In the "INPUT AND OUTPUT PROPERTIES" marked

    IsSorted properties to - True

    and the output columns marked ID column to SortKeyPosition to 1.

    Please find the attached XML file.

    Could you please help me out how to load all these into table?

    Thanks for your help.

  • June 8, 2009 at 12:25 am

    #1005914

    Please don't cross post.

    Discussion in thread http://www.sqlservercentral.com/Forums/FindPost729749.aspx.


    Lutz
    A pessimist is an optimist with experience.

    How to get fast answers to your question[/url]
    How to post performance related questions[/url]
    Links for Tally Table [/url] , Cross Tabs [/url] and Dynamic Cross Tabs [/url], Delimited Split Function[/url]

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply