DTS Lookups - generating and testing unique keys

Hi,

I'm using SQL Server 2000 DTS to transform data from one table to another. As part of this I need to combine several fields into a unique key in the new table.

As DTS is processing how do I test if the key hasn't already been used and generate a new unique key e.g. by adding a number to the end of the key ?

Regards

Michael

[361 byte] By [ASGMikeG] at [2007-12-25]