Permission denied message for table creation while executing a DTS

[mmuzaffar]

Hi

I fighting with a strange problem with a DTS package, we had a DTS package under a name of user who left the company and his account was deactivated, i openned that DTS package and saved it under my name and my user is part of sysadmin role, when i am trying to execute the DTS i gets the error message permission denied unable to create table (database name)
while i can crete/delete tables in that particular database manualy via query analyser as well as through enterprise manager but when i am trying to do that through a DTS as mentioned above i always gets the permission denied message
any help will be highly appreciated
thanks

Ramis

 

[Catadmin]

You need to comb through the package looking for Dynamic Properties tasks that set an .ini file or any Execute SQL tasks that might set specific users. Even check all the connections. Something is hidden somewhere in Workflow properties or regular properties which is causing it to execute under this old User's login.

If the above doesn't help, repost this in the DTS forum (forum961). They can get you a more specific answer than most of the people on this forum.





Catadmin - MCDBA, MCSA
"No, no. Yes. No, I tried that. Yes, both ways. No, I don't know. No again. Are there any more questions?"
-- Xena, "Been There, Done That"