"Jerry J" wrote:

>
> I am using SSIS to import data from a SQL server database to an identical
> SQL server database. I get the following error on almost all my tables. It
> looks like it is complaining that I have duplicate keys, but the source
> database is identical with the same constraints. Duplicate keys are not
> possible. I have "Keep Identity" checked and check constraints not checked. I
> am using "table or view - fast load".
>
> Please help!
>
>
> An OLE DB error has occurred. Error code: 0x80004005.
> An OLE DB record is available. Source: "Microsoft OLE DB Provider for SQL
> Server" Hresult: 0x80004005 Description: "The statement has been
> terminated.".
> An OLE DB record is available. Source: "Microsoft OLE DB Provider for SQL
> Server" Hresult: 0x80004005 Description: "Violation of PRIMARY KEY
> constraint 'PersonSpecialty_PK'. Cannot insert duplicate key in object
> 'dbo.PersonSpecialty'.".
>
>
>
> --