SQLXMLBulkLoad Question (Please help)

I posted this last week and no one posted a reply. I'll try to re-word the
question so it's clearer as to what I'm asking.

I'm running SQLXMLBulkLoad from a vb.NET app supplying both and xml file and
a schema (xsd) file. The data is getting loaded into the table except for
columns that contain spaces or empty strings. These columns are being
populated with NULLS.

Is there anyway to instruct SQLXMLBulkLoad to load columns with empty
strings (or columns that contain only spaces) and retain those values instead
of populating with a Null?

The XML input was created from a dataset (WriteXml) and I'm trying to load
this data into another database and it needs to retain all values (i.e. empty
strings). I expected that column tags that are missing from the xml file
would be loaded as nulls but columns such as <tag1></tag2> would load as an
empty string.

I've searched for this problem extensively but can't find that anyone has
experienced this problem. However, it seems so basic (Null vs empty string)
I would think that if SQLXMLBulkLoad did not load data correctly that other
people would have reported this since Null and empty string handling are so
basic from a database perspective. Am I missing something here?

.

Relevant Pages

  • Re: SQLXMLBulkLoad Question (Please help)
    ... >> Is there anyway to instruct SQLXMLBulkLoad to load columns with empty ... >> The XML input was created from a dataset and I'm trying to load ... I expected that column tags that are missing from the xml file ... it seems so basic (Null vs empty string) ...
    (microsoft.public.sqlserver.xml)
  • RE: SQLXMLBulkLoad Question (Please help)
    ... >>> Is there anyway to instruct SQLXMLBulkLoad to load columns with empty ... I expected that column tags that are missing from the xml file ... >>> people would have reported this since Null and empty string handling are so ... Am I missing something here? ...
    (microsoft.public.sqlserver.xml)
  • RE: SQLXMLBulkLoad Question (Please help)
    ... I'm running SQLXML 3.0 SP3. ... >> The XML input was created from a dataset and I'm trying to load ... I expected that column tags that are missing from the xml file ... it seems so basic (Null vs empty string) ...
    (microsoft.public.sqlserver.xml)
  • Re: SQLXMLBulkLoad Question (Please help)
    ... Is there anyway to instruct SQLXMLBulkLoad to load columns with empty ... The XML input was created from a dataset and I'm trying to load ... I expected that column tags that are missing from the xml file ... it seems so basic (Null vs empty string) ...
    (microsoft.public.sqlserver.xml)
  • Re: SQLXMLBulkLoad Question (Please help)
    ... "Graeme Malcolm" wrote: ... > The XML input was created from a dataset and I'm trying to load ... I expected that column tags that are missing from the xml file ... it seems so basic (Null vs empty string) ...
    (microsoft.public.sqlserver.xml)