SYMPTOMS
When you try to generate a schema by using the SQL Transport Schema Generation Wizard in Microsoft BizTalk Server 2004, you receive the following error message:
Type "http://www.w3.org/2001/XMLSchema:char" is not declared or not a simple type. An error occurs at , (0, 0).
WORKAROUND
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>