title: SSIS Error Code DTS_E_OLEDBERROR: 0xC0202009
body: <p>I created a new package today, it gets info passed down from a Master package that runs other packages as well. My master package pulls the connection info from a config file at runtime. Protection level = DontSaveSensitive. Using Windows Authentication. It works fine locally but when I run it from a job it gives me the error below. </p>
  
  <p>Any ideas or constructive comments are welcome!</p>
  
  <blockquote>
    <p>Code: 0xC0202009     Source: DFT - Insert Into StageSites Source DB TEICommon [1]     Description: SSIS Error Code DTS_E_OLEDBERROR.  An OLE DB error has occurred. Error code: 0x80040E14.  An OLE DB record is available.  Source: "Microsoft SQL Server Native Client 10.0"  Hresult: 0x80040E14  Description: "Statement(s) could not be prepared.".  An OLE DB record is available.  Source: "Microsoft SQL Server Native Client 10.0"  Hresult: 0x80040E14  Description: "Invalid column name 'SuspendedDate'.".  An OLE DB record is available.  Source: "Microsoft SQL Server Native Client 10.0"  Hresult: 0x80040E14  Description: "Invalid column name 'FirstShipmentDate'.".  End Error  Error: 2016-10-28 10:38:02.50     Code: 0xC004706B     Source: DFT - Insert Into StageSites SSIS.Pipeline     Description: "component "Source DB TEICommon" (1)" failed validation and returned validation status "VS_ISBROKEN".  End Error  Error: 2016-10-28 10:38:02.50     Code: 0xC004700C     Source: DFT - Insert Into StageSites SSIS.Pipeline     Description: One or more component failed validation.  End Error  Error: 2016-10-28 10:38:02.50     Code: 0xC0024107     Source: DFT - Insert Into StageSites      Description: There were errors during task validation.  End Error</p>
  </blockquote>
  
  <p>Update: [Fixed]
  I solved the issue by updating my schema in the database my ETL query was pulling from.</p>