Error while executing SSIS Package When I tried executing a SSIS Package I came across following error.


  [OLE DB Destination [148]] Error: 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_user'. Cannot insert
  duplicate key in object 'dbo.users'. The duplicate key value is (-3)."


I was trying to pull data from one table to another table across two DB servers.
How can I proceed further?
Looks like you are trying to insert duplicate PK_user IDs into your destination table, that is set to be unique as well. 

You'll need to join the 2 sets and only write the unique PK_user results or remove the unique constraint on your destination table.