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 ] 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?