Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
SQLXMLBulkLoad eats CR in CRLF
Message
Information générale
Forum:
Microsoft SQL Server
Catégorie:
Import/Export
Divers
Thread ID:
01447843
Message ID:
01447937
Vues:
40
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--
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform