Relational Data to XML via VB 6.0 / XSD?

I’m working on several different applications written in VB 6.0 which convert relational data into XML Files. The applications were written to conform to specific schemas (XSD Files) and works fine as long as the relational data and the schema do not change in their structure. This seems like the wrong approach to properly using XML Technologies – any sample code to make this type of transformation more robust?

Thanks,
-Shane