Can’t transform xml data received from SQl Server.

Home Page › Forums › BizTalk 2004 – BizTalk 2010 › Can’t transform xml data received from SQl Server.

Viewing 0 reply threads
  • Author
    Posts
    • #18673

      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.

Viewing 0 reply threads
  • The forum ‘BizTalk 2004 – BizTalk 2010’ is closed to new topics and replies.