Yes, but how could we validate the XML output with a predefined XSD. I don't think this is optimal solution to the requirement. Please suggest.

Hi rs80 and All,

The idea is use to SSIS to generate complex XML files with multiple elements in it, hierarchical. It is also must to validate this XML against XSD....

Hi Gary,

Did you try Keelio software. What is your feedback? I need to generate XML from multiple elements sourced from file,database etc. and write multiple nodes, parent child relations to...