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.
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.
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?
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.
+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.
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?
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.
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.
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.
Thanks a lot for explaining all in detail and showing all the methods to resolve the task.
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.
Excellent. Three solutions in one video.
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?
Thank you Sir , well explained!!!
Very helpful video!!
Excellent video, very neatly explained.
Nice explanation..thank u
Good Explanation
Thanks Sir! But how to create XSL file from multi level xml ?
Very useful video. Thanks a lot.
Awesome video! Thanks.
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.
+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.
Thanks for the great video. In the Approach 3, how did you create the XSL file?
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?
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?
Excellent, very detailed and well explained. Can you recommend tools to help you create an XSL file? Thanks.
BookStore attribute is not inserted anywhere in the SQL could you please explain how to pull the information in the root Tag
Hey Nice Video..
But in 3rd approch How can I create XSL file for my multilevel XML?
Dude, how after 4 years did you not at least provide a single link to simple explanation on creating an xsl file???
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.
How to create xsl file from multilevel XML ?
How to create a xslt file
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.
thank you for this video but how do you create .xsl file. can anybody explain me? Thanks
how to convert xml to xsl file
useful thanks
This glosses over a very problematic common situation with multiple namespaces and makes it impossible to generate xsd file