June 5, 2006 at 9:43 am
Hi. I'm getting these errors when doing a Fuzzy Grouping in SSIS - can anyone assist?
[Fuzzy Grouping Inner Data Flow : DTS.Pipeline] Error: component "Fuzzy Lookup" (69) failed the pre-execute phase and returned error code 0x8000FFFF.
[Fuzzy Grouping [82]] Error: A Fuzzy Grouping transformation pipeline error occurred and returned error code 0x8000FFFF: "An unexpected error occurred.".
I only get this error on large volumes of data - 1.5 million rows. It works fine on a small recordset. I am running the package from a Windows Server desktop with 512mb RAM, pointing to a database on a Windows Server (also a desktop) with 1024mb RAM.
I have tried both a DataReader and OLE DB Source as input to the Fuzzy Grouping.
Could this be a memory issue?
If you can help, I'd be very grateful! I can't seem to find anything to help me on the web.
Wayne
June 8, 2006 at 8:00 am
This was removed by the editor as SPAM
June 21, 2006 at 2:18 pm
Do you have SQL Server 2005 SP1 installed on both machines? There was a memory leak problem with Fuzzy Lookup/Grouping that SP1 fixed.
I'm sure I've run across this error during my testing but can't remember exactly what caused it right now. It's been a while since you posted, did you figure it out?
I normally use OLE DB Source and Destination and haven't played with the DataReader yet.
37SOLUTIONS
We'll find the solution that's right for you!
Website Hosting | Website Design | MSSQL/MySQL Hosting | Database Development | Research/Consulting
June 21, 2006 at 2:34 pm
September 18, 2007 at 8:49 am
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply