Hello JLingenfelder,
the most obvious problem is the missing XMLDATA-Part. So “For XML Auto, XMLDATA” should make it work. After adding the metadata, before running your orchestration alter the procedure and delete the “, XMLDATA”. Otherwise the schema wil be delivered with your data – at least that’s how I interpreted it when I had this problem.
To make the “ELEMENTS”-part work you seem to have to do a few things. I for my part just mapped the whole thing to a schema of my liking.
Regards, Michael