none
SSIS - Error Code 0x80004005 RRS feed

  • Question

  • I have searched through many forums concerning this error:

    Error at Load Data Table Position Requisition [Load Data Table SFactor_PositionReqisition [1]]: 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 coud not be retrieved from Oracle.".

    An OlE DB record is available.  Source: "Microsfot OLE DB Provider for Oracle" Hresult: 0x80004005 Description: DataType is not supported.".

    Error at Load Data Table Position Requisition [Load Data Table SFactor_PositionRequisition [1]]: Opening a rowset for "PHSF"."SFACTOR_POSITIONREQUISITION"" failed.  Check that the object exists in the database.

    Additional information

    |__> Exception from HRSULT: 0xC02020E8 (Microsoft.SqlServer.DTSPipelineWrap)

    I am using SQL Server 2008 R2 (BIDS).

    I think I get the issue as this only occurs on one of five table loads and this table is trying to take an NTEXT (Excel) data column and send it to a NCLOB Oracle (10g) data table.  This behavior was not experienced until I added the NCLOB column to the data table.  The data is required and setting the Oracle data column to VARCHAR2(2000) is not large enough to hold the data being imported. 

    Is there a way to import the data to an NCLOB with this version of SSIS?  Maybe transform the data from NTEXT to TEXT to Varchar(Max)?  Any help and direction offered will be greatly appreciated.

    Thank you.


    MT

    Wednesday, January 27, 2016 6:26 PM

Answers

All replies

  • Hi MT,

    DataType is not supported

    Pretty much explains this mishap.

    What is the data in the source, is it text, and how large? You need to find the max as perhaps NVARCHAR2 can do (4k chars)


    Arthur

    MyBlog


    Twitter

    Wednesday, January 27, 2016 7:12 PM
    Moderator
  • Sorry for the delay, I lost track of this.

    I should point out that I am new to the Oracle world but not SSIS.  Although I have not experienced this before. 

    The data source is Excel within the package and the largest element for this column is currently 3,989 characters.  I agree that this should fit within a VARCHAR2.  However, I have been unsuccessful in converting in down from DT_NTEXT to a compatible data type. 

    Any possible suggestions to resolve this are greatly appreciated.

    Thank you.


    MT

    Tuesday, February 16, 2016 10:48 PM
  • Got same error code in Win 10 loading STL file to Print 3D program
    Sunday, October 27, 2019 3:13 AM