Transforming XML schema with SQL sevice schema.

Hi ,

I am totally new in biztalk server and suffered with a problem.

I have to integrate two databases with biztalk server 2004. So i have written a small orchestration which takes XML files as input and give it to SQL Adapter.

A xml schema is taken as a input message through which orderID is taken as primary key and given to SQL Adapter to call a stored procedure in SQL Adapter.

For that purpose there is need to transform XML schema to SQL service schema. I have transformed it but it gives me error of \”Use of unconstructed messgae of SQL Service Request\”.

Please tell me how can i proceed to transform these two schema.

Any suggestion will be accepted.

Thanks in advance

Jyotsna