DSXchange

Not sure I entirely understand your question "or should I be able to export the structure of the XML file to the XML Input Stage"..... in fact, that "is" the technique that you need if there are multiple rows and is what it sounds like you are doing above based on my prior recommendation.

or maybe I'm confused ? : )

Ernie

Sorry, Ernie, didn't see that this had flipped to a second page.

I thought using the SOAPBody column was a kludge just to get the data out and that there would be a different way to use moving forward.

Anyways, this is all working fine for several days now and I'm into the UNIT testing of the downstream database load, so everything is good.

Thanks for your help on this Ernie and others!

Rob

There is working going on to enhance our xml capabilities, and hopefully such work will then make its way into the "related-to-xml" stages...but until then, the WSTransformer is single row....so you have nailed it in the best way!

Ernie