Thanks Koen for the suggestion.

The query I had in mind was incomplete. It should be like this:

ALTER TABLE [Table Name] ADD AUTOID INT IDENTITY(1,1)

DELETE FROM [Table Name] WHERE...

Koen Verbeeck (11/26/2014)

---

riyaziq (11/25/2014)

---

As Lowell pointed out, you are inserting duplicate primary key values into the table which is not permitted.

You need to add a 'Sort' component in your Data...

As Lowell pointed out, you are inserting duplicate primary key values into the table which is not permitted.

You need to add a 'Sort' component in your Data Flow task.Right click...