Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

SSIS with oracle data source Expand / Collapse
Author
Message
Posted Friday, October 4, 2013 11:32 AM
SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: General Forum Members
Last Login: 2 days ago @ 4:41 PM
Points: 1,770, Visits: 3,202
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
Post #1501708
Posted Friday, October 4, 2013 11:36 AM
SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: General Forum Members
Last Login: 2 days ago @ 4:41 PM
Points: 1,770, Visits: 3,202
figured out, it seems it doesnot like inline comments
Post #1501710
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse