I wonder if anyone can advise, I have an xml file as below:
Using this XSD file
But in the SSIS package it doesn't recognise the field names. I'm new to using XML and any help would be very greatfully received. Many thanks
(comments are locked)
|
Try after adding
and your xsd could be
Basically, the root tag is missing in the xml file. You can name it anything. Hope it helps. That's done it, many thanks.
Apr 12, 2012 at 03:38 PM
Mrs_Fatherjack
(comments are locked)
|
Have you checked the exact case? XML is case sensitive. As far as I can tell it's all the same, our database uses case sensitive collation so I'm used to checking it.
Apr 12, 2012 at 12:31 PM
Mrs_Fatherjack
(comments are locked)
|
Do you still get the issue if you get SSIS to generate the XSD?
(comments are locked)
|