I 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 permissions