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 |
|
clange
Starting Member
2 Posts |
 Posted - 2004-10-12 : 13:47:09
|
| I have a dts task (SQL 2000) that moves billing data around for accounting clerks. They call me to execute it. I’d like to give the clerks the ability to run the task, but I don’t want them stumbling around in Enterprise Manager. I cannot just schedule the task, because the timing is dependent on manual unpredictable tasks that the clerks must complete in advance.I can save the dts task to a file and I can execute it via a command line saved in a .bat file. What is the least permission and lightest install I would need to give my clerks to run a dts task from their workstations? |
|
|
jen
Master Smack Fu Yak Hacker
4110 Posts |
Posted - 2004-10-13 : 02:04:01
|
quote:
Originally posted by clange
I have a dts task (SQL 2000) that moves billing data around for accounting clerks. They call me to execute it. I’d like to give the clerks the ability to run the task, but I don’t want them stumbling around in Enterprise Manager. I cannot just schedule the task, because the timing is dependent on manual unpredictable tasks that the clerks must complete in advance.I can save the dts task to a file and I can execute it via a command line saved in a .bat file. What is the least permission and lightest install I would need to give my clerks to run a dts task from their workstations?
if you can execute the batch file without changing any settings but your clerks can't? just clarifying...--------------------keeping it simple... |
 |
|
|
clange
Starting Member
2 Posts |
Posted - 2004-10-13 : 10:58:56
|
| Yes, I can, but then I have all the SQL Server tools installed on my workstation, I am a domain admin, and a SQL sysadmin. What do my clerks need installed on their workstations, and what is the least role/permission I need to give them so they can run it. |
|
|
|
jen
Master Smack Fu Yak Hacker
4110 Posts |
Posted - 2004-10-13 : 22:55:01
|
can you create a batch file for them or an exe file to execute the package? you don't need to give them permissions, just allow them to use your rights without them knowing it. the permission will be embedded in your exe file.check for run dtshope this helps... --------------------keeping it simple... |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2004-10-14 : 13:58:42
|
| At a minimum, they'll need dtsrun.exe. Try just that and let us know if they can run it.Tara |
|
|
|
|
|
|
dts: lightest possible install