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. I know other ETL tools have this capability but we need to use SSIS for this purpose. Please let me know. If SSIS is not capable what scripting, tools or SQL Server or what we can use to achieve this requirement? Whatever we use the component should be generic for all the ETL jobs so that multiple XML files can be generated reusing the functionality. Are tools like CozyRoc, Keelio capable of doing this? Can they accept multiple input streams and compose complex XML's?

Please share your inputs.