Anyone know a way around this one?

I needed to get XML data from a web service. The web service (which I can't
change) outputs some of the elements as CDATA. Doesn't look like the XML data
provider included in RS2005 can handle these. Thinking it might be a problem
with the web service I created this quick test:

Create an empty XML Data Source (i.e. with an empty Connection String).

Put this into the query and it will return the values:

<Query>
<XmlData>

<Simple>
   <SomeInfo>Hello</SomeInfo>
   <SomeInfo>World</SomeInfo>
</Simple>

</XmlData>

</Query>

However, put this in and it doesn't work:

<Query>
<XmlData>

<Simple>
   <SomeInfo><![CDATA[Hello]]></SomeInfo>
   <SomeInfo><![CDATA[World]]></SomeInfo>
</Simple>

</XmlData>

</Query>

Annoying....