I am extracting a query from Oracle DB source. I have set the connection manager as OLE DB source from Oracle. When I run the package, No rows are sent to the destination while the package is shown to be good.
While I use the same query with ADO NET source, the rows are sent to the destination.
The OLE DB connection is working fine with other packages. Other packages have around 1k-5k rows this has 200k+ rows. Are the number of rows might be the case?
How to fix this?