BizTalk Server Framework - How to make SQL adapter work with underscore in column names of SQL table

Author

How to make SQL adapter work with underscore in column names of SQL table

nikhiltayal

2005-02-23, 5:58 pm

I need to design an orchestration which will insert records in SQL tables
using SQL adapter in BTS 2004. The table columns have underscore (_) in
them and U read that:
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.

Being a novice in XSD, I'm wondering if I somebody have a sample on how to
get around with this? Removing underscore is not possible for us as the
database is already existing and is being used by 100s of other apps.

Any help is appreciated.

thanks
Nikhil