BizTalk Server General - Retrive "real" XML from SQL Server database column?

Author

Retrive "real" XML from SQL Server database column?

Bizdeveloper[00]

2006-04-10, 7:34 pm

Hi...

No... this is not how to retrive relational data from a database...

I would like to know if it's possible to retrive "real" xml from a database
column using the SQL Adapter (BTS2004) without converting the xmltags ("<"
and ">") to "<" and ">" ?

The SQL Adapter doesn't work if we exlude the "for xml"-clause in the SELECT.

I know you shouldn't save xml in a database like this but I can't do
anything about it.

Please let me know if it's possible..