InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comSun, 19 May 2013 20:49:01 GMT20http://www.sqlservercentral.com/Forums/Topic729729-148-1.aspx[quote]I have downloaded a 30-day trial version of Keelio XML Destination Adaptor. The product does a lot, but does not natively support CDATA. I tried creating the CDATA as a string in the SQL Command source ('' ). However, the < and > are not interpreted as tags by the XML Editor, they appear as the greater than > and less than < symbols. Any help would be greatly appreciated. [/quote]I don't know what are your needs but here are fast facts Microsoft XML columns don't support CDATA sections because I have seen six tables shopping cart in CDATA sections, so to avoid data corruption and other issues Microsoft does not support CDATA sections in SQL Server. However the .NET XML classes which are in your application layer support CDATA section.Sun, 07 Jun 2009 13:16:23 GMTGift Peddiehttp://www.sqlservercentral.com/Forums/Topic729729-148-1.aspxI have downloaded a 30-day trial version of Keelio XML Destination Adaptor. The product does a lot, but does not natively support CDATA. I tried creating the CDATA as a string in the SQL Command source ('<![CDATA[' + rtrim(field_name) + ']]>' ). However, the < and > are not interpreted as tags by the XML Editor, they appear as the greater than &gt; and less than &lt; symbols. Any help would be greatly appreciated. - <AMS_DOC_XML_EXPORT_FILE VERSION="1.0" EXPORT_DATE="2009-06-04" DOC_CAT="AR" DOC_TYP="RE" DOC_CD="RE" DOC_DEPT_CD="1503" DOC_UNIT_CD="null" DOC_ID="value" DOC_VERS_NO="1" AUTO_DOC_NUM="false" DOC_IMPORT_MODE="OE">- <RE_DOC_HDR AMSDataObject="Y"> <DOC_CAT Attribute="Y"><![CDATA[11521044]]></DOC_CAT> </RE_DOC_HDR> </AMS_DOC_XML_EXPORT_FILE>Fri, 05 Jun 2009 08:00:25 GMTgkline