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