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 |
|
mayan12
Starting Member
10 Posts |
 Posted - 2004-06-23 : 15:11:51
|
| Is it possible to run a DTS package from a stored procedure?If yes how would I go about doing this? |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2004-06-23 : 16:15:30
|
| You can with dtsrun.exe. You would need to use xp_cmdshell to call dtsrun.Tara |
 |
|
|
Wanderer
Master Smack Fu Yak Hacker
1168 Posts |
Posted - 2004-06-24 : 07:27:23
|
| example:exec master..xp_cmdshell 'dtsrun /S x0007472 /E /N Populate_SLS_tables'*##* *##* *##* *##* Chaos, Disorder and Panic ... my work is done here! |
|
|
|
|
|
|
Run DTS package from a stored procedure