title: SSIS: database xyz cannot be opened. It is in the middle of a restore
body: <p>In SSIS 2008, is there is way to design an SSIS package around the problem when an OLE DB data source returns an error like this "Database [xyz] cannot be opened.  It is in the middle of restore."?</p>
  
  <p>I am hoping there is a way to design a loop into an SSIS 2008 package to trap this error, maybe wait 5 or 10 minutes for the source DB to finish restoring (from log shipping for example) and then try again - with a max retry limit built in.</p>
  
  <p>Thank You.</p>