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-10-25 : 09:50:23
|
| Dan writes "How do I execute a DTS package from a stored procedure. I am using SQL Server 2000 with Windows NT.Thanks,Dan H." |
|
|
jasper_smith
SQL Server MVP & SQLTeam MVY
846 Posts |
Posted - 2002-10-25 : 10:39:48
|
| 3 real options1) Use DTSRUN via xp_cmdshell2) Use sp_OA* procedures with the Package Object and the LoadFromSQLServer and Execute methods3) Create a job that runs your DTS package using CmdExec jobstep and DTSRUN and call sp_start_jobOf these (1) is probably the easiest but requires xp_cmdshell accessDetails of the Package Object and DTSRUN utility are in BOLHTHJasper Smith |
 |
|
|
|
|
|
Execute DTS package from stored procedure