SSIS OLEDB Destination Insert fail for Data Access Mode Table or View


I have OLEDB DEstination to insert to a table using Table or View Data Access Mode (Not Fast Load).
My table has a trigger AFTER INSERT, which will update a status.

When executing in Production, Package throws the below error.

An OLE DB error has occurred. 
Error code: 0x80004005.  
An OLE DB record is available.  
Source: "Microsoft SQL Server Native Client 11.0"  
Hresult: 0x80004005  
Description: "Cannot find the object "MYTABLE_Response" because it does not exist or you do not have permissions."

The table has permissions (SELECT/INSERT/DELETE/UPDATE)

It ran succcessfully in UAT but not in Prod.
Any response on this will be helpful.

asked on Stack Overflow Oct 4, 2018 by seshi kumar • edited Feb 7, 2020 by Gryu

1 Answer


Here are some possible solutions:

  1. Get the DBA to triple check that the account used in the connection manager has the appropriate access to the table/database.
  2. Verify that when the package runs in Prod that it's connecting to the database that you expect it to connect to, i.e. is it configured/parameterized correctly?
  3. Verify the table actually exists in Prod.
answered on Stack Overflow Oct 4, 2018 by Jeremy J.

User contributions licensed under CC BY-SA 3.0