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.
SSIS Error Code DTS_E_OLEDBERROR. 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.
Here are some possible solutions:
User contributions licensed under CC BY-SA 3.0