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