[ashishhevale]

Hi

I am getting duplicate rows from flat file source and oledb destination has primary unique key on that column

So to remove duplicate what is better
sort ascending the column and check remove duplicate
aggregate using group by

There are not more that 1000 rows for each execution so data is very less

I dont want to use temp table please

I cannot do it with sql command in oledb destination as insert query with select query


Any idea pls