question

Bheemasenacharya avatar image
Bheemasenacharya asked

Error code: 0x80004005.

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 10.0" Hresult: 0x80004005 Description: "The statement has been terminated.".

An OLE DB record is available. Source: "Microsoft SQL Server Native Client 10.0" Hresult: 0x80004005 Description: "Violation of PRIMARY KEY constraint 'PK_S001T01'. Cannot insert duplicate key in object 'dbo.S001T01'. The duplicate key value is (Apr 14 2021 4:00PM).".

(SQL Server Import and Export Wizard)

database
10 |1200
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

1 Answer

·
shahzaib5 avatar image
shahzaib5 answered

@Bheemasenacharya
Check your table 'dbo.S001T01' schema first if the Primary key is set to the Date column which cannot allow duplication of records in this column.

10 |1200
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.