How To Avoid Duplicates in Dataport

Hi ,

Is there any way to avoid Duplicates while Importing Data(DataPort) other than Primary Key,

IF so any sample code or any method

please help me out…


as a first I idea i would use a tmp TABLE inserting the whole input file then looping through the TMP table retriving only the unique row, finally insert into the destination.

Maybe this a quick and dirty solution but I’m pretty sure that should works,



I Already Have Duplicates in my Table,My Client Dont Want any more duplicate Data from now, They need an error alert While Importing Data.

Or is there any way to avoid duplicates in table