Thanks for the reply...

I want to clear my question , I think this will be easy to understand.

we have a 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, because some time data is loading into the working hour also, at the same time end user can not sit idle. so that time the deadlock occurs.

for that reason I want the script or any alternate solution so that i can resolve the issue.

Thanks.