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..