Donate. I desperately need donations to survive due to my health

Get paid by answering surveys Click here

Click here to donate

Remote/Work from Home jobs

Error while Copying data from SQL Server to Oracle

on

I am trying to copy data from SQL Server to Oracle and I am getting the below error:

Could not connect destination component.

Error 0xc0202009: Destination - TBLCOMPESGNOTES [40]: SSIS Error Code DTS_E_OLEDBERROR. An OLE DB error has occurred. Error code: 0x80004005. An OLE DB record is available. Source: "Microsoft OLE DB Provider for Oracle" Hresult: 0x80004005 Description: "Unspecified error". An OLE DB record is available. Source: "Microsoft OLE DB Provider for Oracle" Hresult: 0x80004005 Description: "Oracle error occurred, but error message could not be retrieved from Oracle.". An OLE DB record is available. Source: "Microsoft OLE DB Provider for Oracle" Hresult: 0x80004005 Description: "Data type is not supported.".

Error 0xc02020e8: Destination - TBLCOMPESGNOTES [40]: Opening a rowset for ""TC_OWNER"."TBLCOMPESGNOTES"" failed. Check that the object exists in the database.

ADDITIONAL INFORMATION:

Exception from HRESULT: 0xC02020E8 (Microsoft.SqlServer.DTSPipelineWrap)

I have checked that the object(table) exists in the database of both the source as well as destination.

What could be the possible reason for this?

Comments

Post a Comment