Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
web7junkie
Starting Member
6 Posts |
 Posted - 2004-04-18 : 13:42:06
|
| HII am trying to load xml data into 2 related tables using sqlxmlbulkload component . the tables already exists. THe problem i am runnign into is that some intermediate tables are being created and dropped during the proess. i ran the profiler and found that it is creating table like __SQLXMLBulkload_ .. during the load process. I cound not find any documentation about this component that it creates intermediate tables. I dont have a table creation permission in the prod database. Pls tell me whether a work around is possible or whether data load is not possible if you dont have create and drop table permissionsthankx |
|
|
Merkin
Funky Drop Bear Fearing SQL Dude!
4970 Posts |
Posted - 2004-04-18 : 20:16:29
|
| HiI've seen you post this now a few times with no luck, sorry about that. I haven't dealt with this much, but my gut feeling is that if you've run a trace and it's generating tables, then that's how it works and there is nothing you can do about it.The only thing I can suggest is that you most likely have create permissions in Tempdb, maybe do your bulkload into a tempdb, then move the data over to your live table.Damian |
 |
|
|
Merkin
Funky Drop Bear Fearing SQL Dude!
4970 Posts |
Posted - 2004-04-18 : 20:21:06
|
| Another, less messy way... Bribe your DBA into creating a new DB on Prod that you have create table rights on as a holding area. Then move data across.Damian |
|
|
|
web7junkie
Starting Member
6 Posts |
Posted - 2004-04-19 : 10:44:27
|
| Hi MerkinThankx for the reply . looks like i am in a soup . I cannot even dream of getting table create permission in production. Hopefully i can find a workaround. Please let me know if u stumble upon any solution.Thankx |
|
|
|
|
|
|
xml bulkload