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 |
|
u2p_inst
Yak Posting Veteran
78 Posts |
 Posted - 2003-05-01 : 01:37:39
|
| Dear all,How to executing DTS from stored procedure??thxoh |
|
|
Merkin
Funky Drop Bear Fearing SQL Dude!
4970 Posts |
Posted - 2003-05-01 : 03:15:17
|
| HiThere are two basic ways to do this.1. Use XP_CmdShell to run the DTSRUN.exe program. I wouldn't recommend that as it means giving SA access.2. Create a job that runs the DTS package, but don't give it a schedule. Then use the sp_start_job proc from the MSDB database to run the job.Damian |
 |
|
|
nr
SQLTeam MVY
12543 Posts |
Posted - 2003-05-01 : 09:59:19
|
| Can also use sp_oacreateseewww.nigelrivett.comsp_oacreate Load DTS Only really useful if you want to change some properties from the SP before running the package.==========================================Cursors are useful if you don't know sql.DTS can be used in a similar way.Beer is not cold and it isn't fizzy. |
|
|
|
|
|
|
executing DTS from stored procedure