|
Home > Archive > BizTalk Server Applications Integration > June 2004 > BT 2004 SQL Adapter Question
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 |
BT 2004 SQL Adapter Question
|
|
|
| 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
| |
| Everett Yang 2004-03-31, 5:39 pm |
| 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
| |
|
| 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
>
| |
| Everett Yang 2004-04-02, 10:52 am |
| 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
| |
|
| 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
>
| |
| Everett Yang 2004-04-05, 11:40 am |
| 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
| |
| Ali Shahzad 2004-06-20, 11:09 pm |
| 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.
> http://support.microsoft.com/defaul...msdn/nospam.asp
>
>
>
|
|
|
|
|