Issue with Oracle-SSIS integration

  • maharaj.narayanan

    SSC Veteran

    Points: 230

    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

  • MMartin1

    One Orange Chip

    Points: 27375

    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?

    ----------------------------------------------------
    How to post forum questions to get the best help [/url]

  • Koen Verbeeck

    SSC Guru

    Points: 258826

    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

  • mcaycedo.it

    SSC Rookie

    Points: 29

    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 4 (of 4 total)

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