How can we fix this issue? Am I missing any driver? Everything looks good but I am encountering this issue when I add OLE DB Destination for oracle provider.
Source: Microsoft OLE DB Provider for Oracle" Hresult 0x80004005 Description: "Unspecified error"
Source: Microsoft OLE DB Provider for Oracle" Hresult 0x80004005 Description: Data Type is not supported
The main exception you are receiving is:
Data Type is not supported
This exception is thrown due to some oracle data types that are not supported in OLEDB such as
Based on the Oracle Provider for OLE DB Developer’s Guide:
Fractional second is not supported for TIMESTAMP data types binding with Command objects.
Other data types may not be supported in OLEDB such as
CLOB data type.
It is highly recommended to use Oracle Attunity connectors instead of OLEDB provider, it guarantees higher performance and it is more supported and have been selected by Microsoft to be included with SQL Server Integration Services
For more information you can check my answer on the link below:
User contributions licensed under CC BY-SA 3.0