.bat file scheduled in ESP Scheduler

Question

question

Kirman asked Jul 13, '11

.bat file scheduled in ESP Scheduler

Hi, I have .bat file which have commands of executing SSIS Package (dtexec). I have 3 packages which are getting executed in .bat file. The ESP Scheduler has this .bat file step to execute , now if I stop this ESP Scheduler will all the 3 packages execution will get stop or all will be running. Thanks in advance.

file dtexec

5

10 |1200

Attachments: Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

bopeavy commented · Jul 13, 2011 at 10:13 AM

I would say if you stop the scheduler it may not stop the bat itself you will need to see if the bat is still running in the task manger processes.

1 ·

Kirman commented · Jul 13, 2011 at 10:31 AM

ok..is there any way to stop the package..explicitly from commandline as we have an execute command do we have the Cancel Command?

0 ·

bopeavy commented · Jul 13, 2011 at 10:34 AM

Is the packages running on the same server as the bat/scheduler? Here is a good article on running ssis http://blogs.msdn.com/b/michen/archive/2007/03/22/running-ssis-package-programmatically.aspx

0 ·

Kirman commented · Jul 13, 2011 at 10:52 AM

it can be a different server...

0 ·

bopeavy commented · Jul 13, 2011 at 10:56 AM

Your going to need to know because that will be the server to run a cmdline against or stop the ssis process from running in the task manager.

0 ·

Answer 1 · 2011-07-13T10:47:03Z

Tim answered Jul 13, '11

Stopping the .bat file once it has called the SSIS packages will not stop the SSIS packages. Since there is a cmd line way to execute SSIS I would assume there is a way to stop a package that is currently executing. I have not ever had the need to do so but a quick Google or BING search should reveal what you need.

10 |1200

Attachments: Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

question