williey
Technical User
- Jan 21, 2004
- 242
My SSIS package errored out on the below error. Microsoft has a hotfix kb912423 for it. Since I'm on SP2, the problem should be fixed with SP2. But I'm still encountering memory leak problem when using Fuzzy Lookup.
The paging file will grow to 2.21G before the package failed though I had set the paging file to system managed.
The table contains about 300k rows and it reference a table with 600 rows. How can this problem be corrected?
------------------------------------------
There are 10 kinds of people in this world. One that understands binary and the other one that does not.
The paging file will grow to 2.21G before the package failed though I had set the paging file to system managed.
Code:
[Fuzzy Lookup [788]] Warning: Not enough storage is available to complete this operation.
[DTS.Pipeline] Warning: A call to the ProcessInput method for input 789 on component "Fuzzy Lookup" (788) unexpectedly kept a reference to the buffer it was passed. The refcount on that buffer was 2 before the call, and 1 after the call returned.The table contains about 300k rows and it reference a table with 600 rows. How can this problem be corrected?
------------------------------------------
There are 10 kinds of people in this world. One that understands binary and the other one that does not.