TopMenu

Stopping execution of SSIS package in SSMS

Sometimes it required to execute the packages from SSMS after deploying it to SSISDB catalog in SQL Server. But what if we want to interrupt the execution in the middle or when package stops the progress or hangs. Recently one of my colleague faced this issue and we somehow couldn’t find any quick solution to stop the running execution of package. We tried to restart integration services and other SQL Server services(Which was kinda silly).

Then I figured it out that it’s something related to SSISDB as we’re executing the package in it. When we execute any package then it launches a process ISServerExec.exe for every execution which is in running in the catalog. Now to see all those running packages in the Sql Server instance follow below steps:

1. Go to the SSISDB catalog in Sql Server management studio. Right Click and select the “Active Executions”. The SSISDB catalog can be found under Integration Services Catalogs as shown in below image:

image

image

Now a window will appear that will show the currently running packages. Now select your desired package your desired package you want to kill and click STOP.

image

Cheers!!! :)

4 comments:

  1. Does this work in legacy deployment model?

    ReplyDelete
  2. Good one, worked for me on SQL Server 2012

    ReplyDelete
  3. Cool.. Worked for me!!!

    ReplyDelete
  4. Hi Amit. Thank you for this usefull post. I tried something different to stop the execution - http://wp.me/p520Q0-6O

    ReplyDelete