title: SSIS Failed Pre-Execute Phase check that the object exists in db
body: <p>I have a SSIS package that brings data from Db2 to SQL Server for 20 tables. All my 20 DFT tasks are inside sequence container. the package is deployed in SSISDB and it intermittently throws the error for one particular object during pre-execute phase.</p>
  
  <blockquote>
    <p>An OLE DB error has occurred. Error Code - 0x80040E14<br>
    check that the object exists in the database.<br>
    Source failed the pre-execute phase and returned the error code 0xC02020E8"</p>
  </blockquote>
  
  <p>Now the object exists in the destination database still it throws the error. The package has all the default settings. </p>
  
  <p>I was reading that changing <code>DelayValidation</code> property to True can resolve the issue. But this <code>DelayValidation</code> exists at 1) the package level, 2) the connection manager level, and 3) at the DFT level. Where should I modify it?</p>