Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

We have some complex SSIS packages, currently in SSIS 2005, that use Execute Process Task in order to call out to do some business logic.

Some of these called programs are not as stable as one could wish for.

What is the simplest way, therefore, to constrain the execution in time, or other metric?

For example, nine times out of ten, the program executes (correctly) in ten seconds. If it runs more than five minutes, kill it and presume it returned an error.

Please presume that changing the programs is not an option.

share|improve this question
up vote 5 down vote accepted



Specify the number of seconds that the process can run. A value of 0 indicates that no time-out value is used, and the process runs until it is completed or until an error occurs.


Indicate whether the process is forced to end after the time-out period specified by the TimeOut option. This option is available only if TimeOut is not 0.

more about Execute Process Task Editor (Process Page)

share|improve this answer
D'oh! Thanks for the quick answer – sdg Jul 27 '11 at 14:26

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.