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 |
|
elwoos
Master Smack Fu Yak Hacker
2052 Posts |
 Posted - 2003-12-04 : 03:58:27
|
| I'm sure this is a daft question but can you execute a DTS from T-SQL. The reason I ask is that I have a DTS that I want users to run but they don't have Enterprise manager, query analyzer etc. but they can execute stored procedures so I was wondering if I could execute the DTS from there.While I'm on the subject, can DTS's be scripted in the same way that views etc can be?thankssteveSteve no function beer well without |
|
|
Merkin
Funky Drop Bear Fearing SQL Dude!
4970 Posts |
Posted - 2003-12-04 : 04:11:09
|
| There are two ways to do this, one is using xp_cmdshell to execute DTSRUN.exe. Thats kinda risky as you don't want your users to be able to run xp_cmdshell.The other one is putting the DTS package in a job with no schedule. You can start the job by calling msdb..sp_start_job Damian |
 |
|
|
|
|
|
execute DTS