Unanswered: Importing XML file getting an error [SSIS]
I'm trying to import an XML file using XML Source but I'm getting an error when I try to generate XSD.
"Unable to infer the XSD from the XML file. The XML contains multiple namespaces."
I have been researching on using an XML Task instead but I couldn't figure out how to be able to strip the [xmlns:dt="urn:schemas-microsoft-com:datatypes"] & [dt:dt="xxxxxx"] from the XML source. Without it, I have no issues.