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 - 2006-10-19 : 07:47:02
|
| Cleveland Steamer writes "I know how to execute Sprocs using a DTS package, but how can I execute a DTS using a SPROC? Can you provide a generic sample? -thanks" |
|
|
khtan
In (Som, Ni, Yak)
17689 Posts |
Posted - 2006-10-19 : 07:54:12
|
use xp_cmdshell to execute dtsrun
KH |
 |
|
|
Lumbago
Norsk Yak Master
3271 Posts |
Posted - 2006-10-19 : 07:54:48
|
| CREATE PROCEDURE dbo.myDTSRunASBEGINDECLARE @Cmd varchar(500)SET @CMD = 'dtsrun ...'EXEC xp_cmdshell @CmdEND--Lumbago"Real programmers don't document, if it was hard to write it should be hard to understand" |
|
|
|
|
|
|
Execute a DTS using a stored procedure