Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2005 Forums
 SQL Server Administration (2005)
 BCP Export Missing XML Declaration

Author  Topic 

PaulTeal
Yak Posting Veteran

67 Posts

Posted - 2008-10-23 : 02:27:38
I am using BCP to export the contents of a column that has an XML datatype to an XML file. Everything is working fine except the XML file is missing the XML Declaration (<?xml version="1.0"?>). I have been trying everything I can think of and nothing seems to work. I must be missing something obvious because in most cases XML files will need the declaration. Does anyone know how to get the declaration in the file?

A new file is created each export.


Paul Teal

PaulTeal
Yak Posting Veteran

67 Posts

Posted - 2008-10-23 : 07:23:11
To clarify: I understand that the XML datatype strips out the XML Declaration and white space. I am not trying to store that in the database; I just want to add it back in the export file when it is created so that it will be well-formed.

Paul Teal
Go to Top of Page
   

- Advertisement -