Thanks for the reply.
This is production DB. we have millions of data which client is keep sending and we have created SSIS package to copy data from excel to the DB.
At the same time when data is loading into the DB, the end user want to catch the data, but the deadlock occurs in the same time.
for that reason I want the script or any alternate solution so that i can resolve the issue.