Data Flow Task can't tranfer all the records

[lifeforest]

Hi,

I am creating a DFT from an Oracle view to a SQL table, it shows in the data flow diagram that there were 1,360,358 rows wait to be transferred, but the destination table only get 872,829 reords. The output shows package finished successfully, without any errors. What's happening here?

Thanks for any help!

 

[manmaria]

Is there any filters at the destination?

 

[lifeforest]

Finally, I solved this problem. It turns out that some NULL value in the data resource conflict with the destination table contraints.

Weird thing is, SSIS package didn't issue any errors, and the result shows package finished successfully, i guess this could be a bug in SSIS?