We are looking into using the SQL adapter in Biztalk to call a SQL server
stored procedure.   Is it possible to send the complete XML document to a
stored procedure as a parameter?

Thanks for you help
Mark

[ Post a follow-up to this message ]

Are you calling the stored procedure for receive or send?  I have not
tested this but for receive, we should be able to pass XML in as a string.

Sincerely,


Everett Yang
DSI - Microsoft BizTalk Server

This posting is provided “AS IS” with no warranties, and confers no rights.
Subscribe at
http://support.microsoft.com/defaul...msdn/nospam.asp
&SD=msdn

[ Post a follow-up to this message ]

Everett,

I'd be calling a stored procedure as part of the send process.   We have a
stored procedure that uses a text parameter to receive and xml document.
It process the document and uses the return code to inform the calling
process if it was successful.   I'd like to use BizTalk to send xml
documents to this procedure for processing.

Mark


Mark
"Everett Yang" <evyang@online.microsoft.com> wrote in message
news:RLpMR02FEHA.660@cpmsftngxa06.phx.gbl...
> Are you calling the stored procedure for receive or send?  I have not
> tested this but for receive, we should be able to pass XML in as a string.
>
> Sincerely,
>
>
> Everett Yang
> DSI - Microsoft BizTalk Server
>
> This posting is provided "AS IS" with no warranties, and confers no
rights.
> Subscribe at
>
http://support.microsoft.com/defaul...msdn/nospam.asp
> &SD=msdn
>

[ Post a follow-up to this message ]

Hi Mark,

I have never tried that before.  I don't know if there is any general
SQLXML restrictions in doing this.  May have to check with SQLXML about
that.  From BizTalk perspective, I see some potential difficulties.  Even
if we are not using the SQL Send Port, we still need to map inbound
document to an outbound document containing this 'embedded' XML.  We'll
need to represent this documented in the original XML.  We will probably
need to escape the reserved characters (< and > ).  The stored procedure
will then have to deal with that.

Sincerely,


Everett Yang
DSI - Microsoft BizTalk Server

This posting is provided “AS IS” with no warranties, and confers no rights.
Subscribe at
http://support.microsoft.com/defaul...msdn/nospam.asp
&SD=msdn

[ Post a follow-up to this message ]

Everett,

The mapping process is where I've been having my problems.  I haven't been
able to successfully map the source XML document into an field of the
destination document.  Any idea on how to complete this would be greatly
appreciated.

Mark

"Everett Yang" <evyang@online.microsoft.com> wrote in message
news:AP84KpMGEHA.3000@cpmsftngxa06.phx.gbl...
> Hi Mark,
>
> I have never tried that before.  I don't know if there is any general
> SQLXML restrictions in doing this.  May have to check with SQLXML about
> that.  From BizTalk perspective, I see some potential difficulties.  Even
> if we are not using the SQL Send Port, we still need to map inbound
> document to an outbound document containing this 'embedded' XML.  We'll
> need to represent this documented in the original XML.  We will probably
> need to escape the reserved characters (< and > ).  The stored procedure
> will then have to deal with that.
>
> Sincerely,
>
>
> Everett Yang
> DSI - Microsoft BizTalk Server
>
> This posting is provided "AS IS" with no warranties, and confers no
rights.
> Subscribe at
>
http://support.microsoft.com/defaul...msdn/nospam.asp
> &SD=msdn
>

[ Post a follow-up to this message ]

I don't think there is an easy way.  We can't nest an XML as is inside an
attribute of a XML document.  You'll need to manipulate the string to
remove all the reserved characters.

Sincerely,


Everett Yang
DSI - Microsoft BizTalk Server

This posting is provided “AS IS” with no warranties, and confers no rights.
Subscribe at
http://support.microsoft.com/defaul...msdn/nospam.asp
&SD=msdn

[ Post a follow-up to this message ]

Yes, this is possible using OPENXML atleast.

Ali

"Mark" wrote:

> Everett,
>
> I'd be calling a stored procedure as part of the send process.   We have a
> stored procedure that uses a text parameter to receive and xml document.
> It process the document and uses the return code to inform the calling
> process if it was successful.   I'd like to use BizTalk to send xml
> documents to this procedure for processing.
>
> Mark
>
>
> Mark
> "Everett Yang" <evyang@online.microsoft.com> wrote in message
> news:RLpMR02FEHA.660@cpmsftngxa06.phx.gbl... 
> rights. 
> [url]http://support.microsoft.com/default.aspx?scid=/servicedesks/msdn/nospam.asp[/ur
l] 
>
>
>

[ Post a follow-up to this message ]