Hi .. Thanks for reply ... But the thing is i have to Update the MAIN table from the Temp table Which is records updated from the CSV ..

So the Work Flow will be

Transfrom the CVS all the records to Temp table

- from temp table to main table

(this transformation need to check the . whether the Record is in MAIN table or not .. I mean complete Record not like single column ..

then if not the record need to be Inserted .. or else .. need to update the record ..)

I have come with some idea may be this is stupid Correct me if i am wrong

Delete all the records from Main table which record are in Temp Table

Then Insert all the TEMP records to the main Table ..

Here I Struck with the DELETING THING ....

I want to Delete all the Records from MAIN Table which are Same as in TEST table ...

Can you .. please .. Help me ..

Thanks

John