title: SSIS Handling Extenal Issues
body: <p>I have an SSIS package that works fine. The package runs every night and takes about 4 hours to complete. I have am a newb to SSIS, so I want to see what my options are. I am not finding anything on the web about these two issues, so any advice is greatly appreciated.</p>
  
  <ol>
  <li><p>What to do when I have an external
  issue such as a power
  failure/accidental restart. Is there
  a way to alert someone or have the
  package begin again on restart.</p></li>
  <li><p>A couple weeks ago there was a
  process that got hung and locked
  table, making the process not
  execute. How is the best way to
  handle ensuring I have the proper
  access before starting and if not,
  get the access. I am ok with killing
  the processes etc.</p></li>
  </ol>
  
  <p>Looking for best practice info. Thanks</p>