stop dts execution - SQL Server Forums

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.

All Forums

General SQL Server Forums

New to SQL Server Programming

stop dts execution

Author

Topic

eugz
Posting Yak Master

210 Posts

Posted - 2013-01-03 : 16:48:09

Hi All.

I ran SQL Server 2000 DTS. Now I need inter-up execution. I click Cancel button but task still executing. What need to do to stop DTS execution?

Thanks.

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2013-01-04 : 02:24:22

are you running it from job or directly from DTS designer?
If from job you can stop job from sql server agent or use sp_stop_job procedure

------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/

eugz
Posting Yak Master

210 Posts

Posted - 2013-01-07 : 09:27:12

Hi visakh16. Happy New Year.

For instance, if my DTS name RDC_Load I need run stop procedure like:

EXEC dbo.sp_stop_job
N'RDC_Load' ;
GO

Is that correct?

Thanks.

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2013-01-07 : 09:32:35

nope...the name should be name of the job and not name of DTS package

------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/

eugz
Posting Yak Master

210 Posts

Posted - 2013-01-07 : 09:57:37

Is a job means current executing task of DTS package? Is that correct?

Thanks.

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2013-01-07 : 10:08:21

yep...the task you created in SQL Server Agent which calls the DTS package.

------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/

eugz
Posting Yak Master

210 Posts

Posted - 2013-01-07 : 10:22:04

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?

Thanks.

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2013-01-07 : 10:33:39

nope... Remember my first question
How are you executing package? from DTS designer or from automated sql agent job?

------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/

eugz
Posting Yak Master

210 Posts

Posted - 2013-01-07 : 10:49:30

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?

Thanks.

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2013-01-07 : 11:30:21

then its directly running package from management studio. then only way is to stop it by selecting and stopping from enterprise manager

------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/

eugz
Posting Yak Master

210 Posts

Posted - 2013-01-07 : 11:36:54

That is exactly what I don't know how it to do. Can you detail explain how stop DTS in my case?

Thanks.

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2013-01-07 : 11:40:42

do you mean you dont see stop button (red) in dts designer?

------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/

eugz
Posting Yak Master

210 Posts

Posted - 2013-01-07 : 11:45:46

Can you detail explain how stop DTS in my case?

Thanks.

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources