MS SQL XML - Having problems with SQLXML bulk import using diffgram

Author

Having problems with SQLXML bulk import using diffgram

Rob Baber

2005-10-27, 5:28 pm

I have a program that writes out xml files that I use to import into SQL
server. When I start importing, most of the files that I have successfully
import, but some of them error out with the message: "SQLOLEDB Error
Description: Empty update, no updatable rows found Transaction aborted".
I've looked at the xml diffgram and there are definitely modified and
inserted rows in it. Has anyone run across this? I'd be glad to post the
diffgram here if anyone would like to see it.

Thanks,

Rob Baber

Michael Rys [MSFT]

2005-10-29, 8:23 pm

Do you use the diffgram or updategram format?

Sending a repro would help.

Thanks
Michael

"Rob Baber" <Rob Baber@discussions.microsoft.com> wrote in message
news:E10640A7-BCE5-42AE-B842- C9956E067812@microso
ft.com...
>I have a program that writes out xml files that I use to import into SQL
> server. When I start importing, most of the files that I have
> successfully
> import, but some of them error out with the message: "SQLOLEDB Error
> Description: Empty update, no updatable rows found Transaction aborted".
> I've looked at the xml diffgram and there are definitely modified and
> inserted rows in it. Has anyone run across this? I'd be glad to post the
> diffgram here if anyone would like to see it.
>
> Thanks,
>
> Rob Baber

Bertan ARI [MSFT]

2005-11-02, 3:23 am

Could you please check the generated T-SQL by the SqlXml by using the
profiler? You are most likely using a diffgram behaving different than your
expectation or hitting a bug in SqlXml.

If you check out the sql and it seems like a wrongly generated one, could
you please post your diffgram and t-sql so that we can investigate if it is
a bug.

Thanks

--
Bertan ARI
This posting is provided "AS IS" with no warranties, and confers no rights.

"Rob Baber" <Rob Baber@discussions.microsoft.com> wrote in message
news:E10640A7-BCE5-42AE-B842- C9956E067812@microso
ft.com...
>I have a program that writes out xml files that I use to import into SQL
> server. When I start importing, most of the files that I have
> successfully
> import, but some of them error out with the message: "SQLOLEDB Error
> Description: Empty update, no updatable rows found Transaction aborted".
> I've looked at the xml diffgram and there are definitely modified and
> inserted rows in it. Has anyone run across this? I'd be glad to post the
> diffgram here if anyone would like to see it.
>
> Thanks,
>
> Rob Baber

Sponsored Links