thanks du2y

I did the same as you said first i did it on source but the package was failing then i did at the destination by connecting the error output...

thanks dazero

i did not get your point of writing the error rows to dump would you elaborate please? actually i am new to ssis

thanks

Thanks man

I did the same way as you told by making the table first in the sql Db and this worked.

But i have round 200 tables on oracle side it...

thanks man for replying

I use data conversion task i am able to convert the data types but it started another issue that i am getting double the number of columns...