How can i import relational XML file in SQL Table ?

• Pravin Patel-491467

  Say Hey Kid

  Points: 674

  More actions

  April 13, 2009 at 2:58 am

  #201916

  Hi all

  I have XML File with relational data. I want to load it in my SQL Table.

  Is there any direct way to load in SQL Table through business intelligence.

  Or is there any other way ? please explain me step by step....

  Thanks,

  Pravin.

• krayknot

  SSCertifiable

  Points: 7998

  More actions

  April 13, 2009 at 3:14 am

  #976426

  Pravin Patel (4/13/2009)

  ---

  Hi all

  I have XML File with relational data. I want to load it in my SQL Table.

  Is there any direct way to load in SQL Table through business intelligence.

  Or is there any other way ? please explain me step by step....

  Thanks,

  Pravin.

  I think this will help you

  http://support.microsoft.com/kb/316005

  kshitij kumar
  kshitij@krayknot.com
  www.krayknot.com

• Girish Bhat

  Ten Centuries

  Points: 1323

  More actions

  April 13, 2009 at 5:41 am

  #976468

  If you are okay with a non-conventional method, you can check my article: http://www.sqlservercentral.com/articles/XML/63687/