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 |
|
clarkbaker1964
Constraint Violating Yak Guru
428 Posts |
 Posted - 2005-01-07 : 14:55:57
|
Does someone have an old link for executing a DTS package from a stored procedure. |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2005-01-07 : 15:00:37
|
| Just use xp_cmdshell with dtsrun.exe, which is a command line way of calling DTS packages.Tara |
 |
|
|
clarkbaker1964
Constraint Violating Yak Guru
428 Posts |
Posted - 2005-01-07 : 15:21:42
|
| Yea I thought of that but I don't want to grant special permissions for my application account to execute xp_cmdshell.I would like to grant rights to execute this one DTS without granting the ability to launch every DTS package that exists on the server. I was thinking i could write the sp to pass the user name and password to the DTS then encript the sp. |
|
|
|
Lumbago
Norsk Yak Master
3271 Posts |
Posted - 2005-01-08 : 07:56:15
|
| Not sure about the rights-management but you can also run a dts by doing this:1. schedule the dts to run at some interval, doesn't matter what, give the schedule a sensible name2. go to Jobs in the sql server agent3. edit the newly created job and delete the schedule4. run the job from your stored procedure using the system stored procedure sp_run_jobHope it helps...--Lumbago"Real programmers don't document, if it was hard to write it should be hard to understand" |
|
|
|
clarkbaker1964
Constraint Violating Yak Guru
428 Posts |
Posted - 2005-01-09 : 12:35:32
|
| Cool that approach may work I'll test that. |
|
|
|
|
|
|
Calling a DTS from Stored Procedure