Can't use Fuzzy Lookup in BIDS A coworker of mine was having an issue with BIDS. He's doing a simple fuzzy lookup and is only looking against two rows (For Testing Purposes). The weird thing is that when he tries to execute a command line prompt appears then vanishes and then the package hangs.

So I had him send me the package and decided to run it myself and found the exact same thing happening?



It will essentially sit like that forever. No error messages or anything. The last message it gives me is this.

[SSIS.Pipeline] Information: Execute phase is beginning.

Now this might be better placed on Superuser or something because I have a hunch as to what the problem is. Our computers are locked down to a frustrating extent. There are several issues I've run into with botched installs and software not working correctly. 

If you have any ideas for what's happening or how to fix it let me know. 

Update: Tried installing this patch to no avail. Doesn't work in 32 bit or 64 bit or as Admin.

Also followed the output and the end is this. SSIS package "Package1 (1) (1).dtsx" finished: Canceled.
Something similar happened to my BIDS after I installed Visual Studio '15 on my dev machine.  There are registry overwrites when a newer version of BIDS/SSDT/Business Intelligence Templates are installed causing failures in older version.  I fixed this by setting up a vm on my local that I only use BIDS on.
Why Can't SQL Server and Visual Studio Get Along?