title: SSIS package execution stops before finishing
body: <p>Today I came across a bug that I'd like to share with everyone.</p>
  
  <p>When trying to execute an SSIS package in Visual Studio (2015 and 2017 the following can happen (note this package was executed sucessfully before).</p>
  
  <p><a href="https://i.stack.imgur.com/9VwQ5.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/9VwQ5.png" alt="enter image description here"></a></p>
  
  <p>While on the bottom it clearly says the SSIS package is finished, the data flow task is still in progress (and will never finish). What also happens (don't know if consistently) a CMD window pops open with "SQLDUMPER.EXE".</p>
  
  <p>This is not due to the way the steps are configured, since executing them individually might still lead to the proper results.</p>
  
  <p>Note as well that in my case this problem makes Visual Studio incredibly unstable. It is not uncommon that after or during every execution Visual Studio crashes completely and is automatically shut down by Windows.</p>
  
  <p>There are no error messages and I had no idea what the reason is this happened untill... (answer below)</p>