Re: Violation of UNIQUE KEY constraint
From: John Bell (jbellnewsposts_at_hotmail.com)
Date: 06/23/04
- Next message: Roy Chastain: "Body type not supported by Remote Host issue"
- Previous message: Peter: "What port will be used if named pipes is the network library used?"
- In reply to: Nirm: "Violation of UNIQUE KEY constraint"
- Messages sorted by: [ date ] [ thread ]
Date: Wed, 23 Jun 2004 09:03:29 +0100
Hi
Try loading the file into a copy of the table (loading table) that does not
contain have the unique constraint. You can then check (write some SQL) to
see what row has the data that will violate the unique contraint
'IX-tblUser' by comparing the data in the loading table and to tblUsers and
within the loading table itself.
Please post DDL ( CREATE TABLE statements (including indexes and keys)) if
you wish for more detailed information.
John
"Nirm" <anonymous@discussions.microsoft.com> wrote in message
news:2013901c458bd$fa946930$a401280a@phx.gbl...
> Hi Guys
> I am trying to import data to a user table using DTS
> Import/Export Wizard in SQL 2000 Server from MS Excel
> 2002, the table has 800 plus rows of data. Necessary
> Identity, Seed and Increment in table design have been
> set. However, data fails to import. I tried importing the
> view and then exporting back to Excel and when try to
> import in user table it throughs error:-
>
> Error at Destination fro Row number 12773. Errors
> encountered so for in this task: 1
> The statement has been terminated.
> Violation of UNIQUE KEY constraint 'IX-tblUser'. Cannot
> insert duplicate key in object 'tblUsers'
>
> Any help will be highly appreciated
> Thanks
- Next message: Roy Chastain: "Body type not supported by Remote Host issue"
- Previous message: Peter: "What port will be used if named pipes is the network library used?"
- In reply to: Nirm: "Violation of UNIQUE KEY constraint"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
