Thank you very much

i appreciate for your Great Help..

Thanks Anjan. May it will work.

ya thats true.

in my requirement they dont want to truncate the destination table.

there is no any uniquely identify the rows.

so i dont thinng i can do it.

is there any way...

Thanks. i got it

ya thats true.

but when i run the package it appending the rows.

how i avoid this one

same rows appending

so i dont know i have to create the SP or identity...