Process Multi-Level XML in SSIS

[@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?

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

[@ganeshasarasati1930]

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

[@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?

[@swethavor]

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

[@naveenk8179]

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

[@papasteve99]

Excellent. Three solutions in one video.

[@ahpitre]

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

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

[@tejaspatel4035]

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

[@sandeepmididoddi6805]

Good Explanation

[@taraajith]

Thank you Sir , well explained!!!

[@Ziadvb971]

Very helpful video!!

[@hemanthreddypadilati5109]

Nice explanation..thank u

[@1300username]

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

[@gokulman3389]

Excellent video, very neatly explained.

[@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?

[@jesicaj6919]

Awesome video! Thanks.

[@saifaddabbagh]

Very useful video. Thanks a lot.

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

[@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

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

[@anilvemana4029]

How to create xsl file from multilevel XML ?

[@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

[@Sarabjitsethi]

how to convert xml to xsl file

[@0aintseennothingyet0]

useful thanks