SQL Adapter Schema Generator Wizard Bug

SQL adapter schema genarator wizard throws an error when the stored procedure parameter contains char(1). There is no KB article for this bug.

Workaround:Make the char(1) to varchar(1) and generate the schema and change it back to char(1) in the stored procedure.

geek's fix:
In BizTalk installation directory, look for XDRtoXSD.xslt and change as follows:

From: <xsl:template mode="convert-datatype" match="@dt:type[.='char']">xs:char</xsl:template>
To: &<xsl:template mode="convert-datatype" match="@dt:type[.='char']">xs:string</xsl:template>
You are all set now.