I'm having some problems importing some XML data files into our SQL Server 2005 database. I've attached a sample xml data file that was given to me by the client, but SSIS doesn't like it. I have several data files to process, this is just one of them, but they all seem to have the same problem.
When I create a data flow tax with an XML source, I browse to the xml data file, and tried to use the "Generate XSD" option in the XML source adapter and got a different message: "Unable to infer the XSD from the XML file. The XML contains multiple namespaces."
I've done a LOT of research online and can't seem to find a solution that works. DO I need to ask the client to provide better data or is this something that can be fixed? Is there some typeof pre-processing I can do to fixup the XML source files so SSIS can read them?