hi all
i have this xml that came from a flat file through a pipeline etc etc
so far it is nicely done

the thing is i have to change some of the values in the xml
for example, i have this tag that is <name>
i want to be modified, changing to be the result of a stored procedure
where an input is the tag name and the result is composed by two
fields
i need them to be returned and from that, modify the xml
adding those to the original
and sending that

how can the "message_1" be modified in that way ?  :D
thanks in advance !

[ Post a follow-up to this message ]

You can use a map.  Set the source schema to what you have now, and create a
second schema with the result node names you want described.

You can use the second schema as the destination schema for the map.

BA



"kerberos" <nirvfan_mty@hotmail-dot-com.no-spam.invalid> wrote in message
news:eIadnaRqpvhYUPDeRVn_vQ@giganews.com...
> hi all
> i have this xml that came from a flat file through a pipeline etc etc
> so far it is nicely done
>
> the thing is i have to change some of the values in the xml
> for example, i have this tag that is <name>
> i want to be modified, changing to be the result of a stored procedure
> where an input is the tag name and the result is composed by two
> fields
> i need them to be returned and from that, modify the xml
> adding those to the original
> and sending that
>
> how can the "message_1" be modified in that way ?  :D
> thanks in advance !
>

[ Post a follow-up to this message ]

There are a few methods that could be used to accomplish this depending upon
how complex your business logic is.

1) In a map using a scripting functoid or custom assembly.

2) In an orchestration calling a custom assembly.

3) In an orchestration using the business rules engine.

--
Jeff Lynch
"A BizTalk Enthusiast"
http://codebetter.com/blogs/jeff.lynch


"kerberos" <nirvfan_mty@hotmail-dot-com.no-spam.invalid> wrote in message
news:eIadnaRqpvhYUPDeRVn_vQ@giganews.com...
> hi all
> i have this xml that came from a flat file through a pipeline etc etc
> so far it is nicely done
>
> the thing is i have to change some of the values in the xml
> for example, i have this tag that is <name>
> i want to be modified, changing to be the result of a stored procedure
> where an input is the tag name and the result is composed by two
> fields
> i need them to be returned and from that, modify the xml
> adding those to the original
> and sending that
>
> how can the "message_1" be modified in that way ?  :D
> thanks in advance !
>

[ Post a follow-up to this message ]