Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

XML Destination - CDATA Expand / Collapse
Author
Message
Posted Friday, June 5, 2009 8:00 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Thursday, June 11, 2009 6:55 AM
Points: 1, Visits: 22
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.

-
-



Post #729729
Posted Sunday, June 7, 2009 1:16 PM
Hall of Fame

Hall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of Fame

Group: General Forum Members
Last Login: Today @ 1:30 PM
Points: 3,428, Visits: 14,432
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.


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.



Kind regards,
Gift Peddie
Post #730414
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse