DTS permission denied to create table to user with SA priviliges

[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

 

[unclerico]

do you have logging turned on for the package?? if you turn on logging and try to execute the package, events are generated in the Windows Event Viewer that should tell you what user tried to execute the package. The user identified in the event may not be who you are expecting it to be. Just something to check on. Also, when you execute the package is it done through Data Transformation Services | Local Packages | Package Name or did you schedule it as a job and try to execute the job, or another way?