question

Kirman1 avatar image
Kirman1 asked

Nested XML File - To Load into SQL Table

Hi, I have a XML File to be load in the SQL Server Table. I tried doing with SSIS 2008 Package but no luck as the XML File have nesting. SSIS have created those many outputs as equal to the nested elements in XML File.It was very hard to understand. Then I came accross a link where the XML file has been saved in XML Document in the SQL Server Table and then on it XML Operations have been perfomed with OPENXML function. The logic worked pretty good but the problem here is to TRAVERSE every element I have to write a whole path for the same. So if there are 50 elements and inside that they have nesting so I have to keep on coding that. Can you please suggest any eaiser way of reading XML files with Nested Structure. Thanks...in need of of urgent help!!.. Thanks You..
sqlxml
1 comment
10 |1200

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

Pavel Pawlowski avatar image Pavel Pawlowski commented ·
Can you put details on the traversing and put here some sample of the XML structure?
0 Likes 0 ·

0 Answers

·

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

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