Hi, I have a dataset which looks like this: Recnr Recid 123 1 123 2 123 201 123 327 I would like to update with the record with MAX(Recid) 327, all the others should not be used in the update. How do I solve that with SSIS? Thanks in advanceLarra

Hi, If you already have this dataset on DFT you can take this way: 1. add a multidifusion after the source component. 2. add an aggregate component and connect to one multicast output. configure the aggregate to get max(recid). 3.add an Order after the aggregate, order by Recid. -- 4. Add a order to DFT and connect it to another multicast output. Order by recid 5. Add a merge join, connect the previous both order components to merge inputs. Configure to inner join. The output provide you a single row with the max recid. Vctor M. Snchez Garca (ES) (BI) Hope this help. Please vote if you find this posting was helpful. if this is an answer to your question, please mark it. http://bifase.blogspot.com | http://twitter.com/atharky