I have since worked with the oracle dbas.  What we saw was nothing made its way to the oracle side.  When I executed the package from the SQL side, there...

More details on this:

source is Oracle with CLOB, destination is SQL 2008.

Using SSIS, the package first truncates the destination table using a SQL task. Then with a Data Flow Task,...