Terminate SSIS package after specific time interval

Question

We are scheduling SSIS packages using Windows Task Scheduler. Every hour the scheduled task will create a new instance of package and start its execution. We need to make sure that previous instance is terminated before next execution starts. Is it possible to terminate package execution from with-in package itself after specific time interval?

Answer 1

In Windows Task Scheduler, if you go to the "Settings" tab of your task, there is a checkbox with the option to "Stop the task if it runs longer than:".

Set this to the desired time interval, and Task Scheduler will kill the process when the specified time is elapsed.