|
Home > Archive > BizTalk Server General > March 2006 > SQL Adapter - Hierarchically Messages
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
SQL Adapter - Hierarchically Messages
|
|
| docnyc@gmail.com 2006-03-16, 8:47 pm |
| A question concerning the BizTalk SQL Adapter, can you call a store
procedure and pass the message as a XML document to the store proc? If
so can you explain how?
Secondly if the answer is no to the above, how do you insert
hierarchically structured XML messages with the BizTalk SQL Adapter?
| |
|
| > A question concerning the BizTalk SQL Adapter, can you call a store
> procedure and pass the message as a XML document to the store proc? If
> so can you explain how?
- I doubt you can pass an XML doc to a stored procedure. Althought you might
wanna double check on this one.
> Secondly if the answer is no to the above, how do you insert
> hierarchically structured XML messages with the BizTalk SQL Adapter?
- You can hierrachically structure XML message with BizTalk SQL Adapter by
using a FOR XML EXPLICIT clause. Please search online for more info. However,
it may not allow to create a complicated XML structure with FOR XML EXPLICIT
in SQL 2000.
"docnyc@gmail.com" wrote:
> A question concerning the BizTalk SQL Adapter, can you call a store
> procedure and pass the message as a XML document to the store proc? If
> so can you explain how?
> Secondly if the answer is no to the above, how do you insert
> hierarchically structured XML messages with the BizTalk SQL Adapter?
>
>
|
|
|
|
|