Troubleshooting when an ETL job stops responding

Solution:

  1. Access SQL Server Management Studio.
  2. Run the command exec_sp_updatestats on the table where the ETL job stops responding.