sql server - SSIS Package Hang randomly on execution phase -

i have master package execute 3 packages. sub-packages has data flow task in extract data excel file placed on shared location, , load sql server database table. each sub package load different file different table. no file or table used in more 1 package.

in bids never face issue, runs smoothly in bids.

but if execute package sql server hang on execution phase , have cancel after long long wait.

the solution found if open excel files once in edit mode close them. , re-run package runs successfully.

the problem have deploy on production server don't have access neither package nor file. , can't ask client open file once in edit mode , close , execute package.

first of can't understand error , secondly solution. please advise. thank you

everything setup on virtual machines.

here log image package hang enter image description here