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.

 All Forums
 SQL Server 2000 Forums
 Import/Export (DTS) and Replication (2000)
 xml bulk load- creates tables

Author  Topic 

web7junkie
Starting Member

6 Posts

Posted - 2004-04-18 : 19:51:43
HI

I am trying to load a xml file into 2 related tables. I had run a trace an found out that the Sql bulkload component is creating intermediate tables like __SQLXMLBulkload_ .... . The target tables already exists. I wanted to know whether the component would always create intermediate tables during the bulkload process or is there any work around. I dont have the create table permissions in the database so the component creating the tables can be a issues.
Any help is much appreciated
Thanks

Merkin
Funky Drop Bear Fearing SQL Dude!

4970 Posts

Posted - 2004-04-18 : 20:19:56
Continued here http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=34291



Damian
Go to Top of Page
   

- Advertisement -