Query on SQL Adapter

Question

I have requirement where the Response Document Root name needs to dynamically changed in the solicit-response sql port.

How can this be achieved?

 

Thanks

 

Answer 1

Can you explain your requirement in more detail?
When do you want to change this adapter property.
Why do you want to change this property?

Answer 2

I need to dynamically decide on the response destination based on some values. Can SQL Adapter be used for dynamic send port? Thanks

Answer 3

Hi

The SQL Adapter does not support dynamic send ports as far as I know. Some people have succeeded (although the solution, as I remember it wasn't all that nice) in sending the request to different servers, ie deciding the connection string at runtime. But the response root node name is hardcoded in the send pot configuration and there is no promoted property to overrule it.

Which version of BizTalk are you using?

If you need to send the response to different places based on some values, this does not sound like you need different response root nodes. This sounds link you just need to promote the values form the generated schema and use that in your filters.

---

eliasen, representing himself and not the company he works for.
Three times MVP and three times MCTS in BizTalk.
Blog: http://blog.eliasen.dk

Answer 4

A dynamic send port has a dynamic destination, not a dynamic response
The response will always be returned to the originating orchestration (that is how solicit/response send ports work) 
You could change the message in the orchestration and publish to the messagebox via a direct port, where another orchestration could consume it
Are the values in the message? If so, why not promote them and use content-based routing? The original orchestration could just ignore the response, but have other orchestrations also subscibing to the response based on promoted properties.