title: SSIS - when a connection is down
body: <p>I've got a simple SSIS package that I edit in VS2008.
  What is basically does is run the same SQL StoredProc, residing in different SQL servers, and aggregating their output into a flat file.
  Simply put, four OLE DB Data Source going to a 'Union All' to output.</p>
  
  <p>If one of the servers is down, how can I make the package skip the validation for that source and therefore the processing, while still aggregating what's possible?</p>
  
  <p>I've had a quick read at ConnectionStrings being in a file, using scripts, etc. hopefully I can avoid this.</p>
  
  <p>I thank you in advance for any help.</p>