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
--sb--