Yes,
it turned out to be an issue of spelling.
I wrote in capital letters elements on the xml, and in small letters on the schema, so sqlbulk load did not parse anything.
Regards
vicpada
Last Activity: Mar 21 '07, 02:23 PM
Joined: Feb 27 '07
Location:
-
Thank you. I already saw it.
I found out what happened. At the was that the fields in the XML file were in capital letter whereas in the schema were in small letter.
When I changed that everything seemed to work perfectly.
:)Leave a comment:
-
my code from asp.net to insert is the following:
class Class1
{
/// <summary>
/// The main entry point for the application.
/// </summary>
[STAThread]
static void Main(string[] args)
{
//
// TODO: Add code to start application here
//
try
{
SQLXMLBulkLoad4 Class bulkLoad = new SQLXMLBULKLOADL ib.SQLXMLBulkLo ad4Class();...Leave a comment:
-
Problems with SQLXML bulk load
Hi all,
I am newbie in all the stuff about xml importing into sql server.
What I try to do is simple. It is take an xml file and drop it into a
table. I am using VS2005, SQLXML 4.0 and SQL Server 2000 (I think
there is no problem of compatibility)
When I run my program using the SQLXMLBulkLoad4 Class class,
everythings seems to run perfect and there is no errors.... -
Ok, thanks!Leave a comment:
-
It is not. I receive the data from a process that generates the data into XML format, and I cannot change the process.Leave a comment:
-
Problems with SQLXML bulk load
Hi all,
I am newbie in all the stuff about xml importing into sql server.
What I try to do is simple. It is take an xml file and drop it into a
table. I am using VS2005, SQLXML 4.0 and SQL Server 2000 (I think
there is no problem of compatibility)
When I run my program using the SQLXMLBulkLoad4 Class class,
everythings seems to run perfect and there is no errors.... -
Problems with SQLXML bulk load
Hi all,
I am newbie in all the stuff about xml importing into sql server.
What I try to do is simple. It is take an xml file and drop it into a
table. I am using VS2005, SQLXML 4.0 and SQL Server 2000 (I think
there is no problem of compatibility)
When I run my program using the SQLXMLBulkLoad4 Class class,
everythings seems to run perfect and there is no errors....
No activity results to display
Leave a comment: