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.