The XML looks good.  Have you checked all the column names to make sure
they all match?

Sincerely,


Everett Yang
DSI - Microsoft BizTalk Server

This posting is provided “AS IS” with no warranties, and confers no rights.
Subscribe at
http://support.microsoft.com/defaul...msdn/nospam.asp
&SD=msdn

[ Post a follow-up to this message ]

Everett,

Everything matches the table. I found this in the BTS2004 documentation.

"Database object names (tables, columns, stored procedures, and parameters),
which are retrieved from sysobjects need to be scanned for the following
special characters. ! @ # $ % ^ & * ( ) _ - + = { [ } ] | \ : ; " '
 < , > .
? / ~ ` If one or more are present, add an XSD restriction to the schema. "

My table columns currently use the "_" such as "po_date". Could this be
causing the problem? If so, the documentation says to add an XSD
restriction. What is an XSD restriction????


--
Jeff Lynch
"A BizTalk Enthusiast"
http://dotnetjunkies.com/WebLog/jlynch/



"Everett Yang" <evyang@online.microsoft.com> wrote in message
news:LqzSKGBdEHA.2972@cpmsftngxa10.phx.gbl...
> The XML looks good.  Have you checked all the column names to make sure
> they all match?
>
> Sincerely,
>
>
> Everett Yang
> DSI - Microsoft BizTalk Server
>
> This posting is provided “AS IS” with no warranties, and confers no
rights.
> Subscribe at
>
http://support.microsoft.com/defaul...msdn/nospam.asp
> &SD=msdn
>

[ Post a follow-up to this message ]

I've changed all the column names in my table to remove the "_" character
and now the insert works fine. The BTS2004 documentation note (see my
previous post) says if the object name contains a special character such as
"_" then I need to add an XSD restriction to my schema.

Not being an XSD expert, could someone explain what this is and how to add
it using BTS2004?

--
Jeff Lynch
"A BizTalk Enthusiast"
http://dotnetjunkies.com/WebLog/jlynch/



"Jeff Lynch" <jeff.lynch@houston-lynch.com> wrote in message
news:%231LlsqBdEHA.3728@TK2MSFTNGP09.phx.gbl...
> Everett,
>
> Everything matches the table. I found this in the BTS2004 documentation.
>
> "Database object names (tables, columns, stored procedures, and
parameters),
> which are retrieved from sysobjects need to be scanned for the following
> special characters. ! @ # $ % ^ & * ( ) _ - + = { [ } ] | \ : ; " ' < , >

.
> ? / ~ ` If one or more are present, add an XSD restriction to the schema.
"
>
> My table columns currently use the "_" such as "po_date". Could this be
> causing the problem? If so, the documentation says to add an XSD
> restriction. What is an XSD restriction????
>
>
> --
> Jeff Lynch
> "A BizTalk Enthusiast"
> http://dotnetjunkies.com/WebLog/jlynch/
>
>
>
> "Everett Yang" <evyang@online.microsoft.com> wrote in message
> news:LqzSKGBdEHA.2972@cpmsftngxa10.phx.gbl... 
> rights. 
>
http://support.microsoft.com/defaul...msdn/nospam.asp
 
>
>

[ Post a follow-up to this message ]

I will do some research and clarify this part of documentation.

Thanks!

Sincerely,


Everett Yang
DSI - Microsoft BizTalk Server

This posting is provided “AS IS” with no warranties, and confers no rights.
Subscribe at
http://support.microsoft.com/defaul...msdn/nospam.asp
&SD=msdn

[ Post a follow-up to this message ]

You will need to add a XSD restriction similar to the following:

<xs:simpleType name="BAMName">

<xs:restriction base="xs:Name">

<xs:pattern
value="[^`~!@#$%^&*()+=\[\]{}\|;'"&gt;&lt;,\?\\]+" />

</xs:restriction>

</xs:simpleType>

You set the base type on the field you want to modify to string, set
derivation type to “restriction” then build a pattern facet.

Sincerely,


Everett Yang
DSI - Microsoft BizTalk Server

This posting is provided “AS IS” with no warranties, and confers no rights.
Subscribe at
http://support.microsoft.com/defaul...msdn/nospam.asp
&SD=msdn

[ Post a follow-up to this message ]