Code: 0xC0202009 Source: Load Changed Rows Insert all rows into fact table  Description: 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_CONSTITUENTPREFERRED'. Cannot insert duplicate key in object 'RE7.CONSTITUENTPREFERRED'. The duplicate key value is (3251414, 184).". End Error
Error caused by unexpected data in The Raiser's Edge database where a record has more then one address marked as preferred. A backup of the database should be made and an attempt at resolving the record.
If you're unable to identify the record have a backup of the database ready and Contact Support and reference this article.