Raj - does your stored procedure have "for xml auto" at the end?  You have
to temporarily add "for xml auto, schema" when are you using the wizard.
The sql adapter needs the ", schema" to generate the xsd.

-Hisham Baz

> Hi All
>
> I am using biztalk 2006 with Sql server 2000(SP4) on windows Server
> 2003 OS(SP1). When I am trying to generate xsd and orchestration using
> "add adapter metadata" wizard after taking select statement or store
> proc wizard is being closed without generating the desired xsd and
> orchestration. I have checked the query, it is ok and running in query
> analyzer. In case of send port using updategram xsd and orch are being
> generated correctly but for select statement or store proc it is not.
>
> Can you please suggest me any solution?
>
> Thanks
> Raj

[ Post a follow-up to this message ]