Issue with Oracle-SSIS integration

  • Hi,

    I'm trying to write the table name and their count of an oracle database. so i hard coded all the select statement with union, when i use the query in source as sql statement i can preview the list

    But when i run the package it throws

    [OLE DB Source [1]] Error: SSIS Error Code DTS_E_OLEDBERROR. An OLE DB error has occurred. Error code: 0x80040E14.

    An OLE DB record is available. Source: "OraOLEDB" Hresult: 0x80040E14 Description: "ORA-00928: missing SELECT keyword".

    i counld'nt find what is the error

    can any one help

  • when i use the query in source as sql statement i can preview the list

    Do you mean you can see the data in the preview of the data flow's source component? Or do you mean your syntax checks out when you query in your Oracle client? The message mentions some type of error with syntax, it thinks there is a missing SELECT clause somewhere. Can you post your code here?

    ----------------------------------------------------

  • maharaj.narayanan (5/25/2014)


    Hi,

    I'm trying to write the table name and their count of an oracle database. so i hard coded all the select statement with union, when i use the query in source as sql statement i can preview the list

    But when i run the package it throws

    [OLE DB Source [1]] Error: SSIS Error Code DTS_E_OLEDBERROR. An OLE DB error has occurred. Error code: 0x80040E14.

    An OLE DB record is available. Source: "OraOLEDB" Hresult: 0x80040E14 Description: "ORA-00928: missing SELECT keyword".

    i counld'nt find what is the error

    can any one help

    It might be useful if you post the actual query.

    Need an answer? No, you need a question
    My blog at https://sqlkover.com.
    MCSE Business Intelligence - Microsoft Data Platform MVP

  • It's and old thread but the problem happened to me today.

    The solution it's in another thread and it's very easy.

    Your query must have inline comments, Remove them.

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply