|
Home > Archive > MS SQL XML > November 2006 > RE: XML Bulk Load is successful, but no data are loaded...
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
RE: XML Bulk Load is successful, but no data are loaded...
|
|
| Rob in Galt 2006-11-07, 7:16 pm |
| I had the same issue.
When I turned on XMLfragment, and removed the dataset name from the data
file, all went fine. In other words - there was no problem in my schema file
to define the tables. The XML bulk loader just didn't know to nagivate to the
first child level in the XML file to find the actual table data.
We have to figure out how to reference the dataset name in the schema file
so that the XML loader understands that the dataset name is the parent whose
children (the actual data tables) it is that we want to get data from.
--
Robert
"Harold Hunsaker" wrote:
> Hello,
>
> I am using the SQL Server 2005 Bulk Loader
> (SQLXMLBULKLOADLib. SQLXMLBulkLoad4Class
) in a VB .NET application to load
> data from an XML file into a SQL Server 2005 database . The application
> executes without error, but there no data are added to the database. I tested
> the app on a simple XML schema and data file that I downlodaed from MSDN, and
> that XML was loaded into the database, so I know the application works
> correctly.
>
> Any idea how I can determine why the Bulk Loader is not loading these data?
> --
> Harold Hunsaker
| |
| Rob in Galt 2006-11-07, 7:16 pm |
| ok - now I get rows - but all NULL data
<xsd:schema id=" PostalCodeTableDS_V1
" targetNamespace="www.goremutual.ca"
xmlns:xsd="http://www.w3.org/2001/XMLSchema"
xmlns:sql="urn:schemas-microsoft-com:mapping-schema">
at the beginning of the file, I tell it the dataaset name in ID and the
target name space is also set
I get rows of data - but all data columns are NULL
Help!
--
Robert
"Rob in Galt" wrote:
[color=darkred]
> I had the same issue.
> When I turned on XMLfragment, and removed the dataset name from the data
> file, all went fine. In other words - there was no problem in my schema file
> to define the tables. The XML bulk loader just didn't know to nagivate to the
> first child level in the XML file to find the actual table data.
>
> We have to figure out how to reference the dataset name in the schema file
> so that the XML loader understands that the dataset name is the parent whose
> children (the actual data tables) it is that we want to get data from.
> --
> Robert
>
>
>
> "Harold Hunsaker" wrote:
>
|
|
|
|
|