Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
SQLXMLBulkLoad eats CR in CRLF
Message
General information
Forum:
Microsoft SQL Server
Category:
Import/Export
Miscellaneous
Thread ID:
01447843
Message ID:
01447937
Views:
39
Try to add following registry key with DWORD value of 0. See http://msdn.microsoft.com/en-us/library/ms171744.aspx for details.
HKEY_LOCAL_MACHINE\Software\Microsoft\MSSQLServer\Client\SQLXML4\SQL2000CompatMode 
>I'm using Doug Hennig's code to import large .dbf files into SQL Server 2008 and have discovered that all chr(13) are removed when importing with SQLXMLBulkLoad.
>
>Using:
>cursortoxml(alias(),lcData,1,512+8,0,lcSchema)
>
>I have verified that the XML file contains the CR+LF
>
>The memo fields are wrapped in CDATA in the XML file.
>
>Any ideas?
--sb--
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform