SSIS Fuzzy Lookup Hangs

I ran into a problem where the Fuzzy Lookup transformation would hang when run from within BIDS. A command prompt window would open and close. It happened too fast to be able to read it.

The lookup involved two relatively small tables so I did not expect any performance issues.


I had set the Run64BitRuntime attribute to False to load an Excel spreadsheet.


It appears that the Fuzzy Lookup needs the Run64BitRuntime attribute set to true to complete successfully. When I changed the Run64bitRuntime attribute from False to True the package ran in a couple of seconds.

This entry was posted in SQL Server Integration Services and tagged . Bookmark the permalink.

3 Responses to SSIS Fuzzy Lookup Hangs

  1. mahesh says:

    Thanks for the post; I was going nuts over this.

  2. Dilli says:

    Many thanks.I got it working .

  3. Nian says:

    Great, thanks. I got exact same problem.

Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s