BizTalk Server Orchestration - Receive SQL adapter

Author

Receive SQL adapter

jcostan@NOSPAMvistali.com

2004-09-08, 7:47 am

Hi,

I am very embarrassed by the use of the biztalk wizard to create a XSD
related to my stored procedure.
I do not have access to the stored procedure which I use, so I can't
insert the XMLDATA necessary.
I tried to create my own XSD refleting the SP but the Receive adapter SQL
does not want it.

Have you a solution to render comprehensible with the adaptor which my
diagram is quite related to an SQL command?

thanks
jérôme

Have a solution

Neal Walters

2004-09-30, 10:40 am

If you get really frustrated and have to get your work done, you can write a
web service that reads the database and call the web service from your
orchestration - thus bypassing the SQL Adapter.

I'd be curious to know if many people use this get-around or not.

Neal Walters
http://Biztalk-Training.com