Re: SQL Send Adapter
- From: "Nikki" <Nikki@xxxxxxxxxxxxxxxxxxxxxxxxx>
- Date: Thu, 1 Dec 2005 06:43:02 -0800
Alan,
I will give this a try and will post an update on the results.
THANKS!!
"Alan Smith" wrote:
> Hi,
>
> You can use an expression shape in the orchestration for this.
>
> 1 Set the field for the XML part of the SQL insert message to distinguished.
> 2 Add an XmlDocument as an orchestration variable.
> 3 Create an espresstion shape
> 4 Add code that looks a like this:
>
> xmlDocument = theMessageYouWantToInsertAsXml;
> sqlMessage.TheFieldThatShouldCOntianThisXml = xmlDocument.OuterXml;
>
> 5 send the message
>
> Hope this helps, shout if it dosn't.
>
> Regards,
>
> Alan
>
> --
> The Bloggers Guide to BizTalk
> http://geekswithblogs.com/asmith
>
>
>
> "Nikki" wrote:
>
> > Marian,
> >
> > thanks for the response.
> >
> > I am clear on how to create the schema and the ports; however, I'm not clear
> > on how to pass the input XML message to the stored procedure. Does BTS do
> > that automatically or do I need to map the inbound message schema to the
> > adapter schema? if the latter, what functoid or other mapping mechanism do I
> > use to
> > pass the entire message, not elements, as input paremeter to the stored
> > procedure?
> >
> > Thanks!!
> >
> > "Marian Drumea" wrote:
> >
> > > The XML schema for the stored procedure call is generated when you use
> > > the "Add Generated Item" feature on the project in VS. Is this what you
> > > are trying? It will ask you to provide namespace and the name for the
> > > request and response roots, as well as the connection string and the
> > > stored procedure you want to call.
> > >
> > > Then, in your orchestration, you can construct the message based on the
> > > generated schema and send it with a Send shape linked to a port of the
> > > type also generated. BTW, you don't need to prepare the parameters on
> > > the stored procedure in any way in order to call it from BizTalk and
> > > there is simple change to have the result returned in XML.
> > >
> > > Does this help?
> > >
> > > Thanks,
> > >
> > > Marian Drumea
> > > http://www.MarianDrumea.com/BizTalk
> > >
> > >
.
- References:
- Re: SQL Send Adapter
- From: Alan Smith
- Re: SQL Send Adapter
- Prev by Date: Re: Schema element types in custom adapter
- Next by Date: Re: BizTalk 2004 :: Business Rules :: firing rule on an index
- Previous by thread: Re: SQL Send Adapter
- Next by thread: Re: Schema element types in custom adapter
- Index(es):
Relevant Pages
|
