Re: How to pass XML document to SQL sp in Orchestration?

Tech-Archive recommends: Speed Up your PC by fixing your registry

From: DougW (DougW.1b5mx3_at_mail.webservertalk.com)
Date: 08/17/04 

Date: Tue, 17 Aug 2004 12:14:00 -0500

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.

Alan Smith wrote:
> *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 each
> 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
> >
> > * 

--
DougW
------------------------------------------------------------------------
Posted via http://www.webservertalk.com
------------------------------------------------------------------------
View this thread: http://www.webservertalk.com/message352118.html

Relevant Pages

  • Re: Pubs in North Shields
    ... A map of locations would be nice as well. ... Alan ... You could try contacting the local branch of CAMRA. ...
    (uk.local.geordie)
  • Re: earthquake forecast calendar maps
    ... my map shows only dates but no magnitude nor location. ... it could be possible to have a map and forecasts for a selection of ... >> Thanks Alan, I linked your earth changes blog into my links page too, you ...
    (sci.geo.earthquakes)
  • Re: Galicia - what is it today
    ... Alan wrote on 10 okt 2007 in soc.genealogy.jewish: ... superimposed over the current international boundaries. ... there's a good map of Galicia from 1882 at ...
    (soc.genealogy.jewish)
  • Re: OT : Greg U Safe from Fires
    ... Alan is located near Mt. ... Etna Park on this map: ... member location map... ...
    (rec.scuba)
  • RE: How to pass XML document to SQL sp in Orchestration?
    ... You could then set this to a string parameter for your SP. ... sub message, using the SQL adapter. ... > I able to pass parameters to a SQL stored procedure using the adapter, ... I am only able to map the data ...
    (microsoft.public.biztalk.general)