Home Forums Programming XML Generating schema and population from XML RE: Generating schema and population from XML

  • You could use SSIS to guess/generate an XSD for you. Create a data flow task with an xml source. If you have the XSD file then even better. Dump the results into a staging table, created with all varchar columns is a safe way to go. You could do a cursory inspection of what you think you might need from here.

    ----------------------------------------------------