Hey everyone,

I have a fuzzy lookup in Integration Services Packages that does not seem to run. I am pulling data from a table in sql server 2008 R2 and comparing results to data from another  table in sql server (same database & instance)  using a fuzzy lookup for match similarities between the data sets. When my data flow task reaches my fuzzy lookup, a DOS box pops up for a second and then my packages finishes with a message of "Finished. Cancelled". The last message in my execution results displays: "Information: Execute phase is beginning". Again, there are no excel files being processed or utilized in this package.   I've tried running my packages both in 32 bit and 64 bit mode but no luck. I've also tried the advice listed Here :

I'm at a loss. Not sure what I can do short of reinstalling Visual Studio.  Any thoughts?

Migince

Info

Visual Studio 2008 3.5 SP1

Version Number: 9.0.30729.4462 QFE

Hi Migince,

The bitness typically is at fault indeed. If I recall right, it works under 64 Bit only.

No need to re-install anything.

Sounds like this to me

http://visakhm.blogspot.in/2012/10/fuzzy-lookup-issues-in-32-bit-runtime.html

Doesn't work. I've tried running with project set to 64bit runtime and 32bit runtime and I get the same result.

Funny thing is, my coworker can run my project no problem on her machine. She's using the same version of Visual Studio 2008 that I am. Could it be a difference in Microsoft.Net version?

How would I be able to reproduce your issue?

She's running .Net 4.5 while I'm running .Net 3.5

Would this affect my fuzzy lookup?

You had a bitness error in the package and the very 1st time SQLDumper appeared which you disregarded

Now I suspect you need to stat over with a new project and all should work

She's running .Net 4.5 while I'm running .Net 3.5

Would this affect my fuzzy lookup?

.net 3.5 is the one SSIS 2008 replies on, so no

Rebuilt project from scratch and still getting the same error whether in 32bit or 64 bit runtime.

then it's time to remove and re-install all the developer tools then apply all the pending SPs.

Yup that did it. Reinstalled and patched my developer tools and everything is working now. Thanks!