Unable to infer the xsd from the xml file. The xml contains multiple namespaces.

Question

I'm importing an xml file using the XML Source task in SSIS. When I click on the Generate XSD it's giving me an error.

Unable to infer the xsd from the xml file. The xml contains multiple namespaces.

This is what my xml file look like.

<x:dataset>
<y:row attribute1='IDvalue' attribute2='value' attribute3='value' />
<y:row attribute1='IDvalue' attribute2='value' attribute3='value' />
<y:row attribute1='IDvalue' attribute2='value' attribute3='value' />
<y:row attribute1='IDvalue' attribute2='value' attribute3='value' />
</x:dataset>

I think it needs to look like this.

<x:dataset>
<y:row/>
<attribute1='IDvalue'/>
<attribute2='value'/>
<attribute3='value'/>
</y:row>
<y:row/>
<attribute1='IDvalue'/>
<attribute2='value'/>
<attribute3='value'/>
</y:row>
<y:row/>
<attribute1='IDvalue'/>
<attribute2='value'/>
<attribute3='value'/>
</y:row>
<y:row/>
<attribute1='IDvalue'/>
<attribute2='value'/>
<attribute3='value'/>
</y:row>
</x:dataset>

How do you format the XML file?

Answer 1

Hi @Thirston Third ,

I'm not familiar with XML.

Someone mentioned that you may strip out the namespaces from xml files.

Check these links to see if it is helpful.

https://social.msdn.microsoft.com/Forums/en-US/2fde216c-01ab-42a5-8b43-52f5f42d35bc/multiple-namespaces-in-an-xml-document?forum=sqlintegrationservices

https://www.sqlservercentral.com/forums/topic/importing-xml-and-ssis

Regards，

Zoe

---

If the answer is the right solution, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".

Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

Answer 2

The xml contains multiple namespaces.

There are two namespace, "x" and "y", but they are nowhere define, so it's invalid (uncomplete) XML.