Process Multi-Level XML in SSIS

[@ganeshasarasati1930]

Thanks a lot for explaining all in detail and showing all the methods to resolve the task.

[@cogsy1598]

I have used Approach 2 before but you have made me want to change all of those to Approach 3. I have seen this before but your explanation was the best I have seen.

[@guyinazo]

Great video. Just started a project that uses a large multilayered XML file and in SSIS I was confused on how to get and join data from each node and this has offered me a direction.

[@papasteve99]

Excellent. Three solutions in one video.

[@taraajith]

Thank you Sir , well explained!!!

[@Ziadvb971]

Very helpful video!!

[@sijanstha4026]

you have explained it very well, I am able to understand each step. Can you please tell how to generate xsl file on the third approach you have explained?

[@hemanthreddypadilati5109]

Nice explanation..thank u

[@sandeepmididoddi6805]

Good Explanation

[@jesicaj6919]

Awesome video! Thanks.

[@saifaddabbagh]

Very useful video. Thanks a lot.

[@gokulman3389]

Excellent video, very neatly explained.

[@swethavor]

Thanks for the great video. In the Approach 3, how did you create the XSL file?

[@786jasmeen]

Very Useful and great video to start off on Multi Level , thanks one question 3rd approch How can I create XSL file for my multilevel XML?

[@varunkumarsvk]

Thank you sir. that was really helpful. Having three approaches in one video with their pros and cons really was helpful. I think the .xsl file that he was talking about is a standard format/template. We can all probably use the same .xsl templates for our loads also. You may have to modify/edit the number of columns and their names and you are good to go. Correct me if I am wrong.

[@durgapalepu5780]

+varun kumar Yes, all that we need to do to create .xsl file is to understand the underlying source xml structure and the desired target xml structure and then creating the .xsl template.

[@naveenk8179]

Thanks Sir! But how to create XSL file from multi level xml ?

[@1300username]

Dude, how after 4 years did you not at least provide a single link to simple explanation on creating an xsl file???

[@ahpitre]

Excellent, very detailed and well explained. Can you recommend tools to help you create an XSL file? Thanks.

[@lekhsharma4448]

How can I reach out to the video author? I have similar type of case and I need some input. Is there any way I can get any type of contact info, please. Video is very good.

[@0aintseennothingyet0]

useful thanks

[@tejaspatel4035]

Hey Nice Video.. But in 3rd approch How can I create XSL file for my multilevel XML?

[@Ccana003]

I have a question... I did Approach 3 but when the file is denormalized and I put it into a XML source, it is now reading the fields as all separate. Any idea why?

[@pragnasarvani5686]

How to create a xslt file

[@vkkpp]

BookStore attribute is not inserted anywhere in the SQL could you please explain how to pull the information in the root Tag

[@anilvemana4029]

How to create xsl file from multilevel XML ?

[@Sarabjitsethi]

how to convert xml to xsl file

[@shrugg22]

Great video. I am sure that author of this video doesn't reply. Can anyone tell me how to get the element "specialty" from first node ? I can do \\bookstore\@Specialty in my xpath but i got multiple elements and idk how to reach all of them and create one output with detail level as well. Any help appreciated.

[@sudarshanghimire5067]

thank you for this video but how do you create .xsl file. can anybody explain me? Thanks

[@nuthouse99]

This glosses over a very problematic common situation with multiple namespaces and makes it impossible to generate xsd file