Thursday 7 August 2014

An OLE DB error has occurred. Error code: 0x80040E14

Error Message:
[StagingLoad [26]] Error: 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: "Deferred prepare could not be completed.".
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 object name 'dbo.Dept'.".


Solution:
  • SSIS Package is unable to find the object "dbo.Dept".
  • Go to connection manager and verify the database, which we have mention in the connection manager.
  • Verify the table "dbo.Dept" availability in the database.

No comments:

Post a Comment