Violation of Primary Key Constraint; SQL Server Express

0

First, I am using SQL Server 2014 Express.

Second, I am using the SQL Server 2014 Import and Export Wizard.

I have imported a few items successfully using this same program. This is the exact error:

Error 0xc0202009: Data Flow Task 1: SSIS Error Code DTS_E_OLEDBERROR. An OLE DB error has occurred.

Error code: 0x80004005. An OLE DB record is available.
Source: "Microsoft SQL Server Native Client 11.0"
Hresult: 0x80004005
Description: "The statement has been terminated.".

An OLE DB record is available.
Source: "Microsoft SQL Server Native Client 11.0"
Hresult: 0x80004005
Description: "Violation of PRIMARY KEY constraint 'PK_GEOG'. Cannot insert duplicate key in object 'dbo.geog'. The duplicate key value is (00, 06, 000001).".
(SQL Server Import and Export Wizard)

This is coming from a flat file source. I have imported this into excel and access and ran various tests. There is no other row in the database that contains (00, 06, 000001) in the first three columns.

These columns make up the primary key (state, type, area). I am no expert but I was not able to find a trigger connected to this table (GEOG).

sql
sql-server
ssis
primary-key
sql-server-express
asked on Stack Overflow Jul 11, 2017 by Tim Wilcox • edited Jul 28, 2017 by Machavity

0 Answers

Nobody has answered this question yet.


User contributions licensed under CC BY-SA 3.0