February 21, 2003 at 7:39 am
I need to have one DTS start another DTS on a different server and run on the other server. Any suggestions?
February 21, 2003 at 10:40 am
Are these scheduled jobs? Do you need the DTS job to run on the other server or is the package on the other server?
If you need it to run on the other server, schedule it, don't need an active schedule, and then make a connection in the DTS on the first server and run sp_start_job.
Steve Jones
February 21, 2003 at 1:39 pm
Steve, I figured it out and it was almost exactly what you said. I wanted to call a DTS package that resided on another server and to run on that server. So I created a job on the second server calling the DTS package. I modified the 1st DTS package to run sp_start_job after creating a connection to the 2nd server. Works like a charm. Thanks!!!
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply