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 |
|
Nitu
Yak Posting Veteran
81 Posts |
 Posted - 2006-06-23 : 11:35:47
|
| Hi all,I am trying to import an xml file to a sql table. For this i created a dts package where there is Execute sql task, and activex script.The activex script is the one which uses sqlxmlbulkload and imports data from xml file into sql table. Before i do this import i want to delete the records in the sql table, for which i have the 'Execute sql task'.My dts is failing on this task as the table that i am trying to empty is in a database for which i am user only. So its giving me this error 'Delete permission denied on object 'tableinsql', database 'sqldatabase', owner 'dbo'Is there a way around this where i can create this package without me being the owner. or any other ideas would be greatly appretiated.Thanks a lot in advance,Nitu |
|
|
nr
SQLTeam MVY
12543 Posts |
Posted - 2006-06-23 : 12:05:56
|
| You don't need to be the owner but if you are going to run this under your login you will need to have delete permission on the table to delete.Maybe get someone to create an sp to do the delete and give you permission on that.You will have to get permission or run it under another login or use another table which you do have permission on.Or find a method that does not require deleting.Do you have permission to insert into the table?==========================================Cursors are useful if you don't know sql.DTS can be used in a similar way.Beer is not cold and it isn't fizzy. |
 |
|
|
Nitu
Yak Posting Veteran
81 Posts |
Posted - 2006-06-23 : 12:52:57
|
quote:
Do you have permission to insert into the table?
I Guess!!! Cause in the same dts Package, the activeX script which inserts data into the same table (which i am trying to delete data from) is running successfully. So i think i have permissions to insert!Thanks for the reply.Nitu |
|
|
|
|
|
|
Any ideas on this one