Ways toload xml(with attributes) into Sql server Table using SqlBulkCopy.

• Patrick.I

  Hall of Fame

  Points: 3105

  More actions

  December 21, 2008 at 4:52 pm

  #94294

  I can load a normal xml data into sql server table using SqlBulkCopy.

  But what do i need to do if the xml has attributes like below e.g:

  I can load the below very easily:

  Thanks in advance

• RBarryYoung

  SSC Guru

  Points: 143329

  More actions

  December 21, 2008 at 6:25 pm

  #915921

  Your XML got eaten by the security filter. Please attach it as a text file.

  [font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung[font="Arial Black"]
  Proactive Performance Solutions, Inc. [/font][font="Verdana"] "Performance is our middle name."[/font]