| Author |
Re: Return Value from SQLXMLBULKLOADLib.SQLXMLBulkLoad3Class.Execu
|
|
| LvBohemian 2005-11-18, 8:24 pm |
| Return Value from SQLXMLBULKLOADLib. SQLXMLBulkLoad3Class
.Execute
In ado.net I am used to getting the number of records affected by the
insert, update etc...
I already have verbose catches for the errors, but it would be nice to know
if it succeded or not even if there was not an error, I have found a number
of conditions where no error was raised and no bulk insert was performed...
thanks in advance.
| |
| Colin Robinson 2005-11-26, 11:23 am |
| Iv found the same it executed didnt hit the catch ex and didnt put any
rowsinto the db
in my case it was down to the autogenerated xml from
dataset.writexml.ignoreschema having a namespace attritute in the root
element Which ia am still struggling to remove ?
ie <dsData xmlns = ".....">
....
</dsData>
Colin
"LvBohemian" < LvBohemian@discussio
ns.microsoft.com> wrote in message
news:E61C3FC8-3F7D-4672-B46A- 399B0B541E32@microso
ft.com...
> Return Value from SQLXMLBULKLOADLib. SQLXMLBulkLoad3Class
.Execute
>
> In ado.net I am used to getting the number of records affected by the
> insert, update etc...
>
> I already have verbose catches for the errors, but it would be nice to
> know
> if it succeded or not even if there was not an error, I have found a
> number
> of conditions where no error was raised and no bulk insert was
> performed...
>
> thanks in advance.
| |
| LvBohemian 2005-11-26, 1:23 pm |
| here is the functioning format I am using, that uses the northwind db...
<Schema xmlns="urn:schemas-microsoft-com:xml-data"
xmlns:dt="urn:schemas-microsoft-com:datatypes"
xmlns:sql="urn:schemas-microsoft-com:xml-sql">
<ElementType name="Shipper" sql:relation="Shippers">
<AttributeType name="ShipperID" required="yes" dt:type="int"/>
<AttributeType name="CompanyName" required="yes" dt:type="string"/>
<AttributeType name="Phone" required="no" dt:type="string"/>
<attribute type="ShipperID"/>
<attribute type="CompanyName"/>
<attribute type="Phone"/>
</ElementType>
</Schema>
| |
| Colin Robinson 2005-11-26, 8:39 pm |
| Looks like the prob is the block:
<Schema xmlns="urn:schemas-microsoft-com:xml-data"
xmlns:dt="urn:schemas-microsoft-com:datatypes"
xmlns:sql="urn:schemas-microsoft-com:xml-sql">
Anyone care to explain this ?
my xsd is actually being generated from visual studio 2005
dataset.writeschema ! is this compatible with sqlxml3.0BulkLoad com object
?
| |
| LvBohemian 2005-11-26, 8:39 pm |
| my functioning sample in my previous post is an XDR not a XSD
| |
| LvBohemian 2005-11-26, 8:39 pm |
| besides being an XDR, my schema is passed as a static parameter that I use
with my bulk inserts, my various XDR's sit on a network share.
|
|
|
|