SSIS with oracle data source

  • I have a SSIS that using Oralce as data source.

    The query is using subqueries.

    And it runs well either in oralce or runs well in BIDs when I click preview.

    But when executing the task, it gives error missing select key word:

    [PS SRC Absence [1009]] 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".

    What could be the reason and how to fix?

    Thanks

  • figured out, it seems it doesnot like inline comments

  • You saved my day also, Thanks.

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

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