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).
User contributions licensed under CC BY-SA 3.0