To work around this problem, use one of the following
methods:
Method 1
In the SELECT statement or the stored procedure you can cast the
column as a
char(2) data type or as a
varchar(1) data type. For example, the following statement changes the data
type from
char(1) to
char(2).
SELECT CustomerID, CAST(CustomerType as char(2)) as CustomerType FROM customers
After you have generated the schema, you can change the SELECT
statement or the stored procedure back to the original form.
Method 2
Modify the XDRtoXSD.xslt xml transformation file that BizTalk
Server uses to transform the SQL data type to an XML data type. The file is
typically located in the C:\Program Files\Microsoft BizTalk Server 2004 folder.
To modify the file, first locate the following line on line 899.
<xsl:template mode="convert-datatype" match="@dt:type[.='char']">xs:char</xsl:template>
After you have located the line, change the line to the following,
and then save the file.
<xsl:template mode="convert-datatype" match="@dt:type[.='char']">xs:string</xsl:template>