Search code examples
sql-servervisual-studiossisetl

SSIS package execution stops before finishing

Today I came across a bug that I'd like to share with everyone.

When trying to execute an SSIS package in Visual Studio (2015 and 2017 the following can happen (note this package was executed sucessfully before).

enter image description here

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".

This is not due to the way the steps are configured, since executing them individually might still lead to the proper results.

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.

There are no error messages and I had no idea what the reason is this happened untill... (answer below)

Solution

  • After a lot of googling i've found a reason whya multitude of people seem to have this problem.

    • Right click the project and then click on properties
    • Click "Debugging"
    • Set "Run64BitRunTime" to "True"

    Apparently for most people this fixes the problem.

    For me however I had to come up with another solution.

    • Right click the project and click on properties
    • Click "General"
    • Set "TargetServerVersion" to either the target SQL server and run the package again OR set it to any SQL server version, run the package to see if it works, and if it doesn't set it to another version.

    These solutions are counter intuitive because this problem seems to arrise at a random moment and the target sql server version might have been the same throughout the entire development.

    I have not tried to see what happens when I deploy the bugged project to a server and see if it runs there, so any and all extra information on this problem would be appreciated.