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.
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 |
|
|
|
|
|