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.

3 comments:

avix said...

Thanks for your kind words

nky said...

http://www.passionforsql.com/2014/08/foreach-item-enumerator-in-foreach-loop.html

on your demand :)

Anonymous said...

Hello,
Are you in need of urgent financial assistance for a personal purpose or for your

business needs? Here is some good news for you. We offer loans to individuals or

corporate firms at the lowest annual percentage rate.
Contact us today to get:-
*Hard Money Loans
*Business Loan
*Debt Consolidation Loan
*Personal Loan
*Business Expansion Loan
*Student Loan
*Agricultural Development Loan
...And Lots more
Email: ahmedakeem411@yahoo.in

FEEDJIT Live Traffic Feed