Thanks Sergey

the answer is absolutely nothing and I should have though of that :-)

>What stops you from adding an extra column for PK (int IDENTITY or uniqueidentifier with newid() as default)?
>
>
>>
>>I've created a data import package to process some csv files and load the data into a database.
>>
>>I'm creating a temporary table and then loading the contents of the csv file into that.
>>
>>How can I include a unique identifier or key in the table I am creating.
>>
>>This is so I can update the temp table with the result of my import and then report out the failures.
>>
>>Thanks
>>
>>Nick