So I've been tasked with importing a bunch of data from a provider into a database and I'm going to try and fumble my way through Integration Sservices this time around to make it all happen. I've got the package working to connect to the web service, login, issue the retrieve commands, etc but the problem is the data is being returned in a format like this;

<?xml version="1.0" encoding="utf-8"?>
<string xmlns="http://websitegoeshere/ws/Scehmas">
<Result xmlns="http://websitegoeshere/ws/Schemas">
<Code>1</code>
</Result>
</string>

Now since it's being returned inside the string element it screws up Integration Services or my knowledge level. Is there any tricks to manipulating the data to have it returned without the string element so IS picks up on the proper bits I need? Is there any good tutorials or documentation available about using IS for this sort of task?

Cheers :)

http://au.php.net/xml_parse
check the related links on the left too

oh youre not in php, nevermind. maybe there are some clues there though.

Perhaps in future you will consider using PHP!

last edited by thermite at 12:49:18 22/Sep/09

http://keithdevens.com/software/phpxml
http://phpxmlclasses.sourceforge.net/

lots of classes already written for you, makes it very easy

If PHP was an option I'd be doing it already or pestering Jim to do it for me.

(much love for PHP)

Please note I have no experience with IS, just some thoughts:



Have you anonymized that namespace for posting? Or is that what its returning? If its got a crap schema your probably gonna be in for some pain. Is there a WSDL with the source? If you do, maybe look around for whether IS can interpret a WSDL?

If all else fails you get IS to request from a PHP service running, which then goes and grabs the XML data from the service and then feeds it back to IS in a format it will like.

IS is grabbing the WSDL but the schema is being returned all within a string which is kind of f***ing ridiculous. This is going to be a painful project :(

Ahh, so its all working, but IS is looking at the results as a giant string rather than an XML object? (please excuse my ignorance).

Nah IS is doing it's thing, the web service is presenting the XML as a giant string!@#% I emailed the data provider about it and their response was that people wanted the data returned as a string.. I think they took it too literally though.

I think they took it too literally though.

Literally would have been sending you a ball of string colored black and white representing binary.