BulkXMLload Error

Hi every now and again (i really can not replicate it) i get the following
error when trying to do a BulkXMLLoad:
"There is already an object named '__SQLXMLBulkload_1112988020_Snapshots' in
the database"
I'm inserting data into a table (called Snapshots) which has an Identity
column and i think this may have something to do with it.
Any help would be greatly appreciated
JonnyDo you have more than one connection open doing bulkload? Looks like you
hit an issue in how we name temporary tables, getting a conflict because
bulkload is trying to create one that already exists. It is a known issue
we're fixing in SqlXml 4.0.
Irwin
"Jonny" <jonny@.nospam.jonnywilk.co.uk> wrote in message
news:d39jnv$l0h$1$8302bc10@.news.demon.co.uk...
> Hi every now and again (i really can not replicate it) i get the following
> error when trying to do a BulkXMLLoad:
> "There is already an object named '__SQLXMLBulkload_1112988020_Snapshots'
> in the database"
> I'm inserting data into a table (called Snapshots) which has an Identity
> column and i think this may have something to do with it.
> Any help would be greatly appreciated
> Jonny
>|||Are you using Bulkload in a multhi-threaded environment?
Thanks.
Bertan ARI
This posting is provided "AS IS" with no warranties, and confers no rights.
"Jonny" <jonny@.nospam.jonnywilk.co.uk> wrote in message
news:d39jnv$l0h$1$8302bc10@.news.demon.co.uk...
> Hi every now and again (i really can not replicate it) i get the following
> error when trying to do a BulkXMLLoad:
> "There is already an object named '__SQLXMLBulkload_1112988020_Snapshots'[
/color]
in
> the database"
> I'm inserting data into a table (called Snapshots) which has an Identity
> column and i think this may have something to do with it.
> Any help would be greatly appreciated
> Jonny
>|||Hi
I think i've found the problem.. Yes i was using it in a multi-threaded
environment and my critical section was initilised correctly
Thanks for the help
Jonny
"Bertan ARI [MSFT]" <bertan@.online.microsoft.com> wrote in message
news:uH1auguPFHA.4024@.TK2MSFTNGP10.phx.gbl...
> Are you using Bulkload in a multhi-threaded environment?
> Thanks.
> --
> Bertan ARI
> This posting is provided "AS IS" with no warranties, and confers no
> rights.
>
> "Jonny" <jonny@.nospam.jonnywilk.co.uk> wrote in message
> news:d39jnv$l0h$1$8302bc10@.news.demon.co.uk...
> in
>|||Sorry that was meant to say "wasn't initilised correctly"
"Jonny" <jonny@.nospam.jonnywilk.co.uk> wrote in message
news:d3h19l$qgc$1$830fa7b3@.news.demon.co.uk...
> Hi
> I think i've found the problem.. Yes i was using it in a multi-threaded
> environment and my critical section was initilised correctly
> Thanks for the help
> Jonny
> "Bertan ARI [MSFT]" <bertan@.online.microsoft.com> wrote in message
> news:uH1auguPFHA.4024@.TK2MSFTNGP10.phx.gbl...
>