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
|
