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.
----------------------------------------------------