Using XML Source File with SSIS
I wonder if anyone can advise, I have an xml file as below:
11
2011-01-02 00:00:01
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
Best Answer
Try after adding `` in your xml. I guess your xml would be something like
11
2011-01-02 00:00:01
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.
As far as I can tell it's all the same, our database uses case sensitive collation so I'm used to checking it.
Do you still get the issue if you get SSIS to generate the XSD?
