sql server web service & biztalk web reference

hi

I have simple sql endpoint:

create XML SCHEMA COLLECTION test AS
N'<?xml version="1.0"?>
<xschema xmlns:xs="http://www.w3.org/2001/XMLSchema">
<xs:element name="res" type="xs:int">
</xs:element>
</xschema>
';

create PROCEDURE test @res xml(test)
AS
BEGIN
...
END

"Add Web Reference" wizard in biztalk project create request Multipart
message type:

<xs:complexType name="testType-res">
<xs:complexContent mixed="true">
<xs:extension
xmlns:q1="http://schemas.microsoft.com/sqlserver/2004/sqltypes" base="q1:xml"
/>
</xs:complexContent>
</xs:complexType>
<xs:element name="testType-res" nillable="true" type="tns:testType-res">
<xs:annotation>
<xs:appinfo>
<recordInfo rootTypeName="testTyperes"
xmlns="http://schemas.microsoft.com/BizTalk/2003" />
</xs:appinfo>
</xs:annotation>
</xs:element>

I can't see my <xs:element name="res" type="xs:int"> from source sql endpoint.
And transform shape offer me only empty sequence that can't be mapped.

I else try to use custom sql endpoint wsdl generation by

EXEC
sp_http_generate_wsdl_defaultsimpleorcomplex
65554, FALSE, N'server01', N'wsdlsimple',
N'NativeWebServices';

and consuming that wsdl by "consume wcf servise" wizard. But result schema is:

<xsd:element name="test">
<xsd:complexType>
<xsdequence>
<xsd:element minOccurs="1" maxOccurs="1" name="res" nillable="true">
<xsd:complexType mixed="true">
<xsdequence>
<xsd:any minOccurs="0" maxOccurs="unbounded" processContents="skip" />
</xsdequence>
</xsd:complexType>
</xsd:element>
</xsdequence>
</xsd:complexType>
</xsd:element>

Why "xsd:any"? Why not "xsd:int"?

How to add correct reference to the sql endpoint in biztalk project?
thanks.

[3345 byte] By [dmitryerkin] at [2008-1-5]