I able to pass parameters to a SQL stored procedure using the adapter, but I
 am not getting my desired result.

How do I create a map that puts my whole XML document into my parameter fiel
d in my stored procedure Schema?  I am only able to map the data within fiel
ds, not whole document.

I am trying to insert thousands of records into a table using OpenXML, but I
 am not able to pass the whole document.

I have also tried to use updategrams, but the performance is much too slow.

Thanks for help!

[ Post a follow-up to this message ]

Hi Doug,

You can get the string content of a message as follows:

msgXmlDocument = Msg;
xmlString = msgXmlDocument.OuterXml;

You could then set this to a string parameter for your SP.

Is there not a limit on parameter size for SPs? I seem to remenber running
into this before, at 8000 chars (4000 unicode), not sure if it still applys.

There are a couple of other optins you could try:

Split up the message into sub-messages for each node, and call an SP with ea
ch
sub message, using the SQL adapter.

Pass the message to a .net class that will then call the database.

Cheers,

Alan


"DougW" wrote:

>
> I able to pass parameters to a SQL stored procedure using the adapter,
> but I am not getting my desired result.
>
> How do I create a map that puts my whole XML document into my parameter
> field in my stored procedure Schema?  I am only able to map the data
> within fields, not whole document.
>
> I am trying to insert thousands of records into a table using OpenXML,
> but I am not able to pass the whole document.
>
> I have also tried to use updategrams, but the performance is much too
> slow.
>
> Thanks for help!
>
>
>
> --
> DougW
> ------------------------------------------------------------------------
> Posted via http://www.webservertalk.com
> ------------------------------------------------------------------------
> View this thread: http://www.webservertalk.com/message352118.html
>
>

[ Post a follow-up to this message ]

Alan,

Thanks for the help, but I don't understand exactly how to do this?  

I am assuming that I should be using the Constuct Assignment and entering:

msgOutbound = msgInbound.OuterXml;

where msgOutbound is a System.String.

I don't think this is right.  Please help.

quote:
Originally posted by Alan Smith 
Hi Doug,

You can get the string content of a message as follows:

msgXmlDocument = Msg;
xmlString = msgXmlDocument.OuterXml;

You could then set this to a string parameter for your SP.

Is there not a limit on parameter size for SPs? I seem to remenber running
into this before, at 8000 chars (4000 unicode), not sure if it still applys.

There are a couple of other optins you could try:

Split up the message into sub-messages for each node, and call an SP with ea
ch
sub message, using the SQL adapter.

Pass the message to a .net class that will then call the database.

Cheers,

Alan


"DougW" wrote:

>
> I able to pass parameters to a SQL stored procedure using the adapter,
> but I am not getting my desired result.
>
> How do I create a map that puts my whole XML document into my parameter
> field in my stored procedure Schema?  I am only able to map the data
> within fields, not whole document.
>
> I am trying to insert thousands of records into a table using OpenXML,
> but I am not able to pass the whole document.
>
> I have also tried to use updategrams, but the performance is much too
> slow.
>
> Thanks for help!
>
>
>
> --
> DougW
> ------------------------------------------------------------------------
> Posted via http://www.webservertalk.com
> ------------------------------------------------------------------------
> View this thread: http://www.webservertalk.com/message352118.html
>
> 

[ Post a follow-up to this message ]