Parsing basic XML with XML Source -
01-18-2006
, 06:24 PM
I'm relatively new to working with SSIS and I'm having a bit of a
problem that I'm hoping someone here can help with. I have a
webservice that I call from a package that returns XML :
<?xml version="1.0" encoding="utf-16"?>
<ArrayOfString xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
xmlns:xsd="http://www.w3.org/2001/XMLSchema">
<string>downloads-632731189255000000.txt</string>
<string>downloads-632731996065468750.txt</string>
<string>weblog-632731189255156250.txt</string>
</ArrayOfString>
I'm trying to take these strings, add them to a recordset, and then
iterate over them. My only problem is that the XML Source is not
providing me with the strings! If I add a root element and change the
XML to something like this:
<?xml version="1.0" encoding="utf-16"?>
<root xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
xmlns:xsd="http://www.w3.org/2001/XMLSchema">
<ArrayOfString>
<string>downloads-632731189255000000.txt</string>
<string>downloads-632731996065468750.txt</string>
<string>weblog-632731189255156250.txt</string>
</ArrayOfString>
</root>
everyhting works fine. Has anyone else had a similar problem? Anyone
know of a good solution?
Thanks!
-Eric |