May 25, 2014 at 4:17 am
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
July 16, 2014 at 6:09 pm
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?
----------------------------------------------------
July 17, 2014 at 1:13 am
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
February 19, 2016 at 7:07 am
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