Load XML file to table with Parent/Child relationship

• Balaji L

  Hall of Fame

  Points: 3067

  More actions

  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.

• LutzM

  SSC Guru

  Points: 107049

  More actions

  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]