• It is the destination that is causing the problem. I posted this on microsoft forum and got the answer.

    https://social.technet.microsoft.com/Forums/sqlserver/en-US/cdd9bc88-ffa9-4ff8-84a9-022a5f9bdffa/ssis-package-hangs-randomly-on-different-tasks-when-scheduled?forum=sqldatawarehousing