I wonder if anyone can advise, I have an xml file as below:
Using this XSD file
<?xml version="1.0"?> <xsd:schema attributeFormDefault="unqualified" elementFormDefault="qualified"
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.
asked Apr 12 '12 at 11:21 AM in Default
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.
Have you checked the exact case? XML is case sensitive.
answered Apr 12 '12 at 11:24 AM
Kev Riley ♦♦
Do you still get the issue if you get SSIS to generate the XSD?
answered Apr 12 '12 at 12:43 PM