0 Replies - 4039 Views - Last Post: 14 September 2012 - 12:10 PM Rate Topic: -----

#1 ashishhevale   User is offline

  • New D.I.C Head

Reputation: 0
  • View blog
  • Posts: 4
  • Joined: 14-April 09

ssis sort or aggregate what is better

Posted 14 September 2012 - 12:10 PM


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

Is This A Good Question/Topic? 0
  • +

Page 1 of 1