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.