| Author |
Topic |
|
humanpuck
Yak Posting Veteran
94 Posts |
 Posted - 2006-03-14 : 10:28:23
|
| Hello,I am running sql server 2000 and I have a DTS package that I'd like an end user to be able to execute. Is there any way to create a "shortcut" to execute a DTS package?Thanks |
|
|
RickD
Slow But Sure Yak Herding Master
3608 Posts |
Posted - 2006-03-14 : 10:49:31
|
If you run this from a stored proc on the server, you can give them rights to the stored proc and they can run it if the stored proc has the right access rights..exec xp_cmdshell 'dtsrun /s <ServerName> /E /N <PackageName>' |
 |
|
|
Srinika
Master Smack Fu Yak Hacker
1378 Posts |
Posted - 2006-03-14 : 11:07:44
|
| humanpuck,Check "command prompt utilities, dtsrun" in BOL |
|
|
|
humanpuck
Yak Posting Veteran
94 Posts |
Posted - 2006-03-14 : 11:34:02
|
| Thanks for both responses. Rick I think that the solution you provided will work for me. Srinika I'd also like to follow up on your solution, but what do you mean by "in BOL"?Thanks again for the help |
|
|
|
Srinika
Master Smack Fu Yak Hacker
1378 Posts |
Posted - 2006-03-14 : 11:36:21
|
| BOL = Books OnLine - The Help of MS SQL Server - U can find it in Start --> Programs --> MS SQL Server ... or In Query Analyzer --> help |
|
|
|
humanpuck
Yak Posting Veteran
94 Posts |
Posted - 2006-03-14 : 11:39:26
|
| Thanks again. |
|
|
|
RickD
Slow But Sure Yak Herding Master
3608 Posts |
Posted - 2006-03-14 : 11:50:01
|
| He's talking about the same solution.. |
|
|
|
humanpuck
Yak Posting Veteran
94 Posts |
Posted - 2006-03-14 : 11:55:54
|
| I noticed when I looked it up. I think the solution is perfect Rick. I can write a stored procedure for the end user to access through our ERP. Just trying to make them less dependant on IT. |
|
|
|
Srinika
Master Smack Fu Yak Hacker
1378 Posts |
Posted - 2006-03-14 : 14:13:12
|
quote:
Originally posted by RickD
He's talking about the same solution..
Not the same !! Using dtsrun and create a bat file and have a "Shortcut" of that BAT file (as requested initially by humanpuck). |
|
|
|
igorblackbelt
Constraint Violating Yak Guru
407 Posts |
Posted - 2006-03-15 : 11:51:46
|
| You can also execute the DTS thru a intranet web page, is that an option to you ?---Thanks!Igor. |
|
|
|
|
Executing a DTS package remotely