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