• I solved this problem by going into Project Properties, Debugging, and setting Run64BitRuntime to false.

    I expect since I'm running 64-bit OS, SSIS thinks it should run 64-bit DTExec, but I only have 32-bit SQL Server installed, so that's an incorrect assumption.

    Hope this helps someone!

    .