Unable to parse xml document

Question

question

Peter001 asked Dec 4, '15

Unable to parse xml document

[link text][1]Hello Techie, may any one please help me with step, how can i move the xml data to sql table. i tried using SSIS and c#, but not able to parse the xml. **file attached herewith** appreciate your help. Thanks, Pete [1]: /storage/temp/3097-xml.txt

xml parsing

xml.txt (1.3 KiB)

1

10 |1200

Attachments: Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Peter001 commented · Dec 04, 2015 at 12:26 PM

Thank You Gents.

0 ·

Answer 1 · 2015-12-04T12:03:15Z

Grant Fritchey answered Dec 4, '15

Here are the basics. You can expand from here. I did have to modify your XML to add a ROOT: DECLARE @DociD INT, @XML NVARCHAR(MAX) = ' 2 Professional Grade 816-8130 2 Professional Grade 816-8130 2 Professional Grade 816-8130 '; EXEC sys.sp_xml_preparedocument @DociD OUTPUT, @XML; SELECT * FROM OPENXML(@DociD,'/root/App',2) WITH (appaction CHAR(1) '@action',id INT '@id',BaseVehicleID INT './BaseVehicle/@id');

10 |1200

Attachments: Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Answer 2 · 2015-12-04T11:54:39Z

Kev Riley answered Dec 4, '15

Your XML is not complete. At the very end there is the end tag ``, so you need a starting tag of `` at the beginning of the document. After that it will be recognised as well-formed XML. Ho to get it into a table is a different question - you would have to define the table structure as I don't know ho you want to handle the various elements

1

10 |1200

Attachments: Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Grant Fritchey ♦♦ commented · Dec 04, 2015 at 12:05 PM

Ah, I didn't copy the whole XML doc. Yeah, having would work instead of the modification I did in adding . I just assumed that it was parsing the XML that was hard, not knowing how to do the INSERT operation.

0 ·

question