overwrite existing record

Tech-Archive recommends: Fix windows errors by optimizing your registry

From: Andrew Gale (AGale10495_at_aol.com)
Date: 10/18/04 

Date: Mon, 18 Oct 2004 13:55:27 -0400

how do i tell my dts package transform data task to overwrite already
existing records with new ones? I already truncated the table and am
inserting about 80000 records, but maybe 63 of them are duplicates. I get a
primary key contraint violation, but i need to have the primary key. On
resume next just skips the record, but i need it to overwrite the previously
inserted one.

I've looked all over for an answer but nothing relevant.... any ideas? 

--
andrew
agale10495@aol.com

Relevant Pages

  • Re: Auto-generate recently visited record-list
    ... Form Company with CompanyID as primary key and autonummered / ... Table History with LogID and FkID ... Allen Browne - Microsoft MVP. ... On the company form I added a combo list CompanyName ORDER BY Inserting ...
    (comp.databases.ms-access)
  • Re: Closing a Database connection
    ... I don't want to be a wise guy, but this table you are inserting a record in, ... programid As String) ... The primary key is the sku. ... This tables is for tracking productivity. ...
    (microsoft.public.dotnet.languages.vb)
  • Re: subscribing table and Primary Key
    ... AFAIK - there is no performance differential between inserting a row where ... the table has a unique as opposed to a primary key. ... Looking for a SQL Server replication book? ... > Will inserts/deletes go through an additional latency if the subscribing ...
    (microsoft.public.sqlserver.replication)
  • Re: SQL Server 2000 / Dataset /Relations Updating
    ... > I recommend you use GUIDs for your primary key, ... > assign those in your dataset, right as you are inserting the rows, and not ... >let's say you have 10 master rows in a dataset, and 20 child rows. ...
    (microsoft.public.dotnet.languages.vb)
  • Re: Data access perfomance
    ... > Hi, thanks I kind reduce the time inserting into the database, the problem ... > was that I had a primary key on the table, ... If you build a new command object for each row you insert, ...
    (microsoft.public.data.oledb)