Import text file not working

[bamundsen]

hello:

I am trying to replace a string of data in one column of one table. I exported the data into a text file, made the required changes to the text file, and tried to import the changes using DTS. I am getting a "violation of primary key constraint PK_products" error. I am not updating the column that is the primary key, why would it give me this error. I am simply trying to update one column.

Any ideas?

Thank you!

Brett