Wednesday, November 27, 2013

SSIS Fuzzy lookup hangs -- resolved


SSIS Fuzzy Lookup gets hanged like below:

While googling, saw that some people faced this issue and solved like delete the existing project and create new projects with copying same package that contains fuzzy lookup.
I also noticed a console window (black color) coming momentarily and disappear then.
Suddenly just to give a try I run without debugging option in BIDS i.e. pressing Ctrl+F5 (or you can choose the option BIDS>Debugging>Continue with Debugging option)
Eventually it runs successfully.
A console screen like below will come and when you press any key it'll let your project run succssfully.

FEEDJIT Live Traffic Feed