| RE: XML Bulk Load is successful, but no data are loaded... |
|
 |
|
 |
|
 |
|
 |
Group: microsoft.public.sqlserver.xml · Group Profile
Author: Rob in GaltRob in Galt Date: Nov 6, 2006 11:11
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
| 
