There is one application in our organization. At starting they got the data from the client and our people were uploading the data manually and what manager did he assigned the target each and every team member after that it will go to the QA department for analyze the data, if there is no issue then it will passed that is how the application was working before.

But problem was there if one user was working at the same time other user logged in the application became slow and if there are 10 user logged in they were not able to work on this because of locking issue.

So to over come this problem they have created SSIS package . the issue almost resolved but the another issue occuring like if 10 records is uploading ...upto 9 record that is working fine but in 10th record, process is hanged.

why I am asking for split the table because there is 270 column and out of 270 columns 79 columns they have created varchar(MAX).

I hope that will be ok for you to understand my proble.

Thanks