I am trying to shred this XML document into separate tables using the XML Source component.
What I am finding is that even thought the shredding process and dataflows of the xml document is not throwing up any errors, the xml document is still not being shredded.
Any suggestions would be greatfully appreciated.
A sample of the xml that I am trying to parse is this ( this is what I am collecting from the data supplier) :-
<?xml version="1.0" encoding="utf-8" ?>
<newsItem encoding="UTF-8" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema">
<headline>And Other Stories wins funding for publishing innovation</headline>
View Complete Post