Hello everyone.
I am working in Visual Strudio 2017, I am loading data from a database on a SQL-Server to a Database on an Oracle Server. The problem is that in the OLE DB Destination the data access mode = Table or View - Fast Load sends the following message:
Exception from HRESULT: 0xC0202040
Error at Data Flow Task [Load Table APP_BONOCOMP_TBLBCRUN (GRANT) [38]]: SSIS Error Code DTS_E_OLEDBERROR. An OLE DB error has occurred. Error code: 0x80040E21.
An OLE DB record is available. Source: "OraOLEDB" Hresult: 0x80040E21 Description: "The system cannot find the message text for message number 0x80040e21 in the message file for OraOLEDB.".
Error at Data Flow Task [Cargar Tabla APP_BONOCOMP_TBLBCRUN (GRANT) [38]]: Failed to open a fastload rowset for ""APP_BONOCOMP"."TBLBCRUN"". Check that the object exists in the database.
We couldn't get the access mode = Table or View to work.
Any idea how to solve this.
Thank you so much
Top comments (0)