Hi there,
Table: tblTestImport
Reference varchar (10) Primary Key
PlannedEnd smalldatetime
CompletionStatus smallint
Outcome smallint
ProvSpecLData1 varchar (15) Primary Key
ProvSpecLData2 varchar (15)

The data comes from a csv file and needs to be run 3 times a day. The PK
combo (on the csv file) can be repeated 5 times.
What I need in the sql table is just the LAST PK combo from the csv file (ie
to update)
What happens when I run the DTS Import wizard is the message:
"Violation of PRIMARY KEY constraint 'PK.....' Cannot isert duplicate key in
object 'tblTestImport'.

How do I get 'round this please

Thanks

Paul
PS I've not really used DTS before.

Run your import into a (tempoary) staging table. Then use normal SQL to
select the data you want and insert it into the real table.


--
Darren Green
http://www.sqldts.com
http://www.sqlis.com


"Paul in Harrow" <PaulinHarrow (AT) discussions (DOT) microsoft.com> wrote