oracle - SSIS Data Flow Task doesn't load all rows from OLE DB -

oracle - SSIS Data Flow Task doesn't load all rows from OLE DB -

i'm trying load table sql server using microsoft ole db provider oracle table (using oracle provider ole db). bundle straight forwards ole db source (sql server) -> ole db destination (oracle).

i'm using sql server 2008 r2 , oracle 11g.

every time run package, different number of rows in destination table, , bids reports fewer rows read there in source table. number of rows returned different each time run it. no errors or kickouts, boxes source , destination remain yellowish after bids says "package completed successfully".

dumping source table flat file instead of oracle destination works fine, , rows expect. can utilize flat file pull info oracle destination table without problems well.

even though have work-around, want understand why happening, , can resolve problem without having utilize flat files.

edit: looks using flat file oracle doesn't bring on rows. first time luck?

edit/update: running bundle out of integration services (not bids) seems have eliminated problem (tested 3 times). still don't understand why happening though.

oracle ssis sql-server-2008-r2