hi

I am new to the DTS. I have a text file and need to be
appended into a table in SQL. This is happening every month
there is a key for the table. However, the text file may
have the duplicates in the key field or the key is alreay
existing in the table in SQL. When I try to import the
data, it fails because of that. Is there any way to let
DTS know not to import any record with key value alreay
existed in the table, instead of failed the process. In
Access database, that is what exactly happens when you try
to import duplicate key value. thanks in advance.

I realize this isn't the direction you want to come from, but I thought I
would throw it out to you anyway in case it helps. You can have a unique
clustered index on the table, with ignore_dup_key, instead of a primary key.
This is roughly the same as a pk, but will allow the table to ignore
attempts to insert records with keys matching a record that already is in
the table.




"wd1153" <weimindai (AT) hotmail (DOT) com> wrote

For this problem you can use lookups.
Here is an example
http://www.sqldts.com/default.aspx?6,107,277,7,1
But always is good idea to import the text file to a phisical temporary
table and then import to the master table, is good if you have errors you
always can rollback or to find duplicates keys.
JFB

"wd1153" <weimindai (AT) hotmail (DOT) com> wrote