dbTalk Databases Forums  

Parsing basic XML with XML Source

microsoft.public.sqlserver.dts microsoft.public.sqlserver.dts


Discuss Parsing basic XML with XML Source in the microsoft.public.sqlserver.dts forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
eric.madariaga@gmail.com
 
Posts: n/a

Default 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


Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.