Sorry I confused. I have DTS package name RDC_Load that include ReloadRx, CustomerReview, RefreshProcess, and so on tasks. If I would like to stop DTS execution completely and current task executing RefreshProcess I need say:
EXEC dbo.sp_stop_job N'RefreshProcess' ; GO
By this way I can stop whole DTS package execution? Is that correct?
I ran DTS package like: In Enterprise Manager SQL Server 2000 I extend Data Transformation Services and select Local Packages. In the right side of screen I got list of DTS packages. I right-click on RDC_Load package and select Execute Package. What I need to do to stop execution RDC_Load package?