If one of our SSIS packages fails because of a communication problem with the backend, and the DBA is not available, my boss wants another individual (probably a senior programmer but not an "sa" type) to be able to re-run the job.
What is the "right" way to do this under SSIS\ sql 2005?
TIA,
barkingdog
this link might help: http://support.microsoft.com/kb/918760/en-us