I have a simple package created with the Import Wizard that reads rows from
a text file to an sql table. The table has a primary key and the text is not
supposed to have duplicate records, but of course it does.

How can I tell DTS to skip duplicates instead of aborting rolling back the
transaction.

TIA
Steve

You should load your text file into a temp table, then use T-SQL in another
task, or procedure, or however you like to import non duplicate rows into
your table so you don't break primary key constraints.

--
Simon Worth


"runningdog" <runningdog (AT) reply (DOT) to.newsgroup> wrote