BizTalk Server Orchestration - Re: Error in completion of orchestration

Author

Re: Error in completion of orchestration

Marian Drumea

2005-12-13, 2:48 am

I understand you have a database, data, and a stored procedure that you
want to call. If the SP returns data and you want to get the schema,
use FOR XML AUTO, XMLDATA (you can also use RAW instead of AUTO). This
will return the data in XML format prefixed by the actual schema. Then,
remove ", XMLDATA" from the SP, once you got the schema.
This is also what you should do if you use Generate Items, but go with
the SQL Adapter instead. It will ask you connection details and the SP
to call. Then, based on the same XMLDATA in SP, it will automatically
generate the schema for you in the BizTalk project. This is what I use
all the time.

Thanks,

Marian
http://www.MarianDrumea.com/BizTalk