I an running a Fuzzy Grouping (attempting to remove duplicates) on 1.2
million rows and I get this error:

[Fuzzy Grouping Inner Data Flow : DTS.Pipeline] Error: component "Fuzzy
Lookup" (69) failed the pre-execute phase and returned error code 0x8000FFFF.

The package fails almost immediately.

I am running this on a P3 server (Dell PowerEdge 2450) with 1GB RAM and 2
processors 933 Mhz, Windows Server Std SP1, SQL2K5 Std (no SP).

I get exactly the same problem on my desktop.

Seems like there is some threshold with fuzzy Grouping, or a memory problem?

The same package works fine with 200,000 rows.

Could anyone please assist me?

Thanks,

Wayne