I’m trying to import data from xml to sql. Here we have around 10 xmls with different schemas. I’m using SSIS to import data from xml to sql. But here I need to generate 10 xsd schema files for each one.

Instead of that how can I combine all these xml/xsd files into one schema file. So need to refer only one xsd source in SSIS.

Any idea to do this.