title: How to fix OLE DB connection manager? (OLE DB source sending 0 rows)
body: <p>I am extracting a query from Oracle DB source. I have set the connection manager as <code>OLE DB source from Oracle</code>. When I run the package, No rows are sent to the destination while the package is shown to be good.</p>
  <p><a href="https://i.stack.imgur.com/CDuxa.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/CDuxa.png" alt="enter image description here" /></a></p>
  <p>While I use the same query with ADO NET source, the rows are sent to the destination.</p>
  <p><a href="https://i.stack.imgur.com/JNSjg.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/JNSjg.png" alt="enter image description here" /></a></p>
  <p>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?</p>
  <p>How to fix this?</p>