One of my scheduled SSIS package is failing daily with below error on one table.
An OLE DB error has occurred. Error code: 0x80004005.
An OLE DB record is available. Source: "Microsoft SQL Server Native Client 11.0" Hresult: 0x80004005 Description: "Transaction (Process ID 149) was deadlocked on lock resources with another process and has been chosen as the deadlock victim. Rerun the transaction.".
When i goggled it some one mentioned to use :WITH (NOLOCK) in source Select query, i did this, Still issue alive and throwing same error
Can anyone suggest on this deadlock issue?