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 |
|
jim65
Starting Member
35 Posts |
 Posted - 2006-02-08 : 10:50:49
|
| Does someone know how to call a DTS from a stored procedures in SQL 2000? Thanks |
|
|
Seventhnight
Master Smack Fu Yak Hacker
2878 Posts |
Posted - 2006-02-08 : 11:26:50
|
Only ways I know are:- to use xp_cmdshell and use DTSRun... - if its a singular DTS, then you could create a job... and then execute the job (sp_StartJob i think?!?)Corey Co-worker on children "...when I have children, I'm going to beat them. Not because their bad, but becuase I think it would be fun ..."  |
 |
|
|
jim65
Starting Member
35 Posts |
Posted - 2006-02-08 : 12:18:04
|
| Thanks, I got it |
|
|
|
|
|
|
call a DTS from Stored procedures