OK, then you need help from an Oracle developer to design your SELECT statement for the OLEDB source.
Select col1, col2
from table
where [convert varchar date and time to datetime] between [startdate] and [enddate]
The problem with trying to do this all in SSIS is that you will always have to process all of the rows in the source table. If the source table is growing, as I mentioned before, your process will get slower and slower.
If you haven't even tried to resolve your issue, please don't expect the hard-working volunteers here to waste their time providing links to answers which you could easily have found yourself.