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 - 2001-11-26 : 09:33:15
|
| Deb writes "Is it possible to fire a DTS package from a stored procedure or Trigger?ThanksDeb" |
|
|
Andraax
Aged Yak Warrior
790 Posts |
Posted - 2001-11-26 : 10:14:06
|
| Deb,you can use the xp_cmdshell extended stored procedure with the DTSRun.exe command line utility. Run DTSRUN /? at a command prompt to get more information. |
 |
|
|
graz
Chief SQLTeam Crack Dealer
4149 Posts |
Posted - 2001-11-26 : 10:20:01
|
| I'd also consider putting the DTS package in a job. Put the DTSRUN.EXE statement in the job. Then you can just launch the job using sp_start_job. It's more of a fire and forget type approach. Don't know your requirements but that's just another way to do it.===============================================Creating tomorrow's legacy systems today.One crisis at a time. |
|
|
|
|
|
|
DTS