Posted - 03/15/2013 : 13:29:32
I'm running a DTS package that creates a CSV file by using 2 temp tables that are created and then dropped.
I run the DTS from a batch file, that runs the DTSRUN utility on a users workstation.
It errs on creating the temp files unless I set the current SQL LOGIN user permissions to "SYSTEMS ADMINISTRATOR" under sever roles, which I DO NOT WANT for these workstation users.
I looked at set permissions like create, set, update etc under DATABASE ACCESS, however I can't chose a TEMP database for access that does not exist or is created and then dropped!
Also, with certain permissions, the DTS will create the temp table, but then it will assign the workstation user as the OWNER and then the DTS will not run because of that.
Note these temp tables and not GLOBAL temp tables (not stored in tempDB) they are created and dropped within my SQL db.
Any ideas here on where and what to set? I just can't figure it out.
Edited by - mrpush on 03/15/2013 13:32:39