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 |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2002-07-16 : 09:21:09
|
| Joseph writes "How do i Run a Dts from a stored procedure?" |
|
|
Page47
Master Smack Fu Yak Hacker
2878 Posts |
Posted - 2002-07-16 : 09:23:20
|
| dtsrun.exe is an OS executable. You can run these using the xp_cmdshell extended stored procedure found in the master database.<O> |
 |
|
|
Merkin
Funky Drop Bear Fearing SQL Dude!
4970 Posts |
Posted - 2002-07-16 : 20:49:44
|
| Another way, if you don't want to allow xp_cmdshell access (and there are lots of reasons not too) is put the DTS package in a job that has no schedule set for it (so it won't run).Then when you want to run it, fire off msdb..sp_start_job with the job name.Damian |
|
|
|
|
|
|
DTS Run from Query Analyzer