Re: SQL Receive Adapter

Tech-Archive recommends: Fix windows errors by optimizing your registry

You will need to modify the schema generated by the SQL adapter to be an
envelope/document schema.
It should look like this (simplified)

<schema> Envelope = Yes
<element name="root"> Body Xpath = <root>
<element maxOccurs="unbounded" ref="document" />
</element>
<element name="document">
<complexType>
<!--elements-->
<complexType>
</element>

So both <root> and <document> are top level nodes and will have
MessageTypes added to the Biztalk config.
This is necessary when the XmlDisassembler debatches the documents, it needs
to find a message type for the debatched document.

This can sometimes get tricky with namespaces, if you have problems, email
me your schema (as SQL adapter generated it)

Greg

"Gary" <Gary@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:5B1DFDD5-282A-42D0-8DC5-3C1B2C20090E@xxxxxxxxxxxxxxxx
Hi All,

I have been experimenting with the SQL receive adapter to pull records via
a
stored procedure, this is purely in a messaging scenario. On my generated
schema I have set both the root and table name element to have a max
occurrs
of 1 however when I configure my send port to pick messages up from the
receive they are output in one file.

My question is, how can I debatch these? I thought that the SQL adapter
would put each record returned into BizTalk as a separate message. Do I
need
to create an envelope schema etc for this or is there a better way to do
this?

Thanks,
Gary


.

Relevant Pages

  • Re: SQL adapter
    ... you can do is to create two updategrams by running the wizard twice, ... update your changed XML Schema. ... > Regarding your post to my SQL adapter question on ...
    (microsoft.public.biztalk.general)
  • Re: SQL Adapter
    ... Jeff, you will need to map from your inbound XML to the SP schema, as ... the SQL adapter expects the input in its format, ... If you set the SQL port up as a request-respose, ...
    (microsoft.public.biztalk.general)
  • SQL Adapter Disassembling Result Sets & Dynamic Parameters
    ... properties of the schema returned in my orchestration. ... Also after processing all the records returned by SQL adapter in my ... from the toolbox drag an xml disassembler ...
    (microsoft.public.biztalk.server)
  • Re: Help in sending Biztalk messages to SQL Server 2005
    ... Use the SQL Adapter to generate an insert schema for you, then map ... After that when you deploy it will create the SQL port for you and ...
    (microsoft.public.biztalk.general)
  • SQL Adapter Disassembling Result Sets & Dynamic Parameters
    ... properties of the schema returned in my orchestration. ... Also after processing all the records returned by SQL adapter in my ... from the toolbox drag an xml disassembler ...
    (microsoft.public.biztalk.general)