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.

10 Comments:
I was experiencing the same issue. Thanks for the work around.
Interesting blog. I have a xforms blog.
You can run an article submission site and article software that gets other people to submit articles, which builds thousands of Google AdSense revenue generating pages without you lifting a finger.
The more I read other blogs it really gives me great ideas. Your is good.
My business management article site is all about business management article.
I think you will like it.
Thanks for the blog. While I was cruising the net, I found your blog on article magazine submission womens. There is an article directory that has good information on article magazine submission womens. You can find it here at article magazine submission womens I will be back to this blog again.
Thanks, Larry
A
Love your post my friend. I just happened to come across your site.
We have a viral online marketing tool that is a really cool viral online marketing tool.
http://corporatestrategicalliances.com/http://corporatestrategicalliances.com/Effective marketing tools, create a wave of traffic hungry for your product/services with this free set of marketing tools in the download area.
Grab your share of internet income with the most explosive discovery now free to download
Duplicate content, web scraping auto bots, article generation software and article spinning. It seems every scaremonger and opportunist has jumped on the article writing band wagon. I still feel that article writing and article marketing are in their infancy - there is much more benefit to be derived from article writing. None of my web sites have suffered from the alleged, duplicate content filter or penalty - very much the opposite. The Article Writing blog is on course to become the number one source of information on article writing and marketing.
Duplicate content, web scraping auto bots, article generation software and article spinning. It seems every scaremonger and opportunist has jumped on the article writing band wagon. I still feel that article writing and article marketing are in their infancy - there is much more benefit to be derived from article writing. None of my web sites have suffered from the alleged, duplicate content filter or penalty - very much the opposite. The Article Marketing blog is on course to become the number one source of information on article writing and marketing.
Post a Comment
<< Home