I'm running an ssis package to tranfer date from an Oracle Table to SQL Server table. There are over 7 million records in the Oracle table.

However, when the job is complete, there are only .2 million records transferred to SQL Server. In Oracle I did a count(*) to see how many records are there. IT still shows 7 million.

The DTS package does not throw any error message. All completed in green.

Any idea why this is happening?