Hello!
My problem is rather trivial, but I haven’t managed yet to solve it. My task is to receive data from sql server, then to transform and to put it into a folder.
An xml file that I receive from the Sql Server via SQL adapter looks like
<qqq xmlns = “http://Test.Start“>
<q1>q1_0</q1>
<q2>q2_0</q2>
<q3>q3_0</q3>
</qqq>
What i need to receive is smth like this:
<?xml version=”1.0″ encoding=”utf-8″?>
<www>
<w1>q1_0</w1>
<w2>q2_0</w2>
<w3>q3_0</w3>
</www>
The problem is that map file can’t recognize message received from SQL server as valid because of “xmlns = “http://Test.Start“”. How can I remove this part of the node? Am I to use xslt or custom pipeline component? Should I remove “xmlns = “http://Test.Start“”? May be I’m on the wrong way?
Please, advise me how to solve this. I’ll appreciate any help.