Hi Brian,
Many thanks for your suggestion. I was able to get it to work correctly.
I'm only into using BizTalk for six weeks now and have lots to learn!
Rita
"Brian Jones" wrote:
> Rita,
>
> Why not use the Schema Generation Wizard in BTS 2006 and let BizTalk
create
> a schema for you? This way, you can either define the SQL Statement or
> Stored Procedure to execute and half your battle is resolved.
Certainly,
> you will have to ensure your SQL or SPROC returns XML, and during the
Schema
> Generation you will have to append your SQL with XMLDATA. For Example:
FOR
> XML AUTO, XMLDATA. This information is used to generate the actual XML
> Schema.
>
> HTH
> --
> Brian Jones
> http://bajwork.blogspot.com
>
|
