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-06-21 : 08:27:22
|
| Chris writes "Can you execute a DTS package from a query? Thanks." |
|
|
jasper_smith
SQL Server MVP & SQLTeam MVY
846 Posts |
Posted - 2002-06-21 : 09:14:22
|
| Look up DTSRUN in BOLIn its simplest form , to run a package called TEST on server SERVER1with Windows authenticationexec master..xp_cmdshell 'DTSRUN /SSERVER1 /E /NTEST'HTHJasper Smith |
 |
|
|
schrockA
Starting Member
2 Posts |
Posted - 2002-06-23 : 22:53:46
|
| Sorry to butt into this discussion, but it's of interest to me as well. Question for Jasper: Thanks for the insight on dtsrun. I'm able to run it from the command line, and that's helpful. But how do I do it from within SQL Query Analyzer? I don't find a procedure sp_cmdshell listed in the Master DB.Al |
|
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2002-06-23 : 23:59:32
|
| It's xp_cmdshell, not sp_cmdshell. |
|
|
|
|
|
|
Executing a DTS package from Query Analyzer