Is the process executed by means of a SQL Agent job?
if so, have you considered letting the SSIS fail, but set the job step to retry x times every y minutes?
____________________________________________
Space, the final frontier? not any more...
All limits henceforth are self-imposed.
“libera tute vulgaris ex”