title: Violation of Primary Key Constraint; SQL Server Express
body: <p>First, I am using SQL Server 2014 Express.</p>
  
  <p>Second, I am using the SQL Server 2014 Import and Export Wizard. </p>
  
  <p>I have imported a few items successfully using this same program. This is the exact error:</p>
  
  <blockquote>
    <p>Error 0xc0202009: Data Flow Task 1: SSIS Error Code DTS_E_OLEDBERROR. An OLE DB error has occurred.    </p>
    
    <p>Error code: 0x80004005. An OLE DB record is available.<br>
    Source: "Microsoft SQL Server Native Client 11.0"<br>
    Hresult: 0x80004005<br>
    Description: "The statement has been terminated.".  </p>
    
    <p>An OLE DB record is available.<br>
    Source: "Microsoft SQL Server Native Client 11.0"<br>
    Hresult: 0x80004005<br>
    Description: "Violation of PRIMARY KEY constraint 'PK_GEOG'. Cannot insert duplicate key in object 'dbo.geog'. The duplicate key value is (00, 06, 000001).".<br>
    (SQL Server Import and Export Wizard)</p>
  </blockquote>
  
  <p>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 <code>(00, 06, 000001)</code> in the first three columns. </p>
  
  <p>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). </p>