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

[ Post a follow-up to this message ]

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

[ Post a follow-up to this message ]