Hi people! I have to import several text files to a certain table in MS SQLSErver 2000. I decided to create a DTS Package. I have a text file (source), a connection and a transformation task. I just selected wich "columns" from file belong to wich columns in table and i executed it. The problem is I have some records repeated in file and it affects the primary key in table. How could i know that record had already been "copied"? I know how to skip an insert (ActiveX Scripting) bnut i dont know how to find the repeated records in file.

Sorry my english and thanks in advance!