Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
Haarish
Starting Member
30 Posts |
 Posted - 2009-11-25 : 01:15:56
|
| Hi All,I have an SSIS package in which I am trying to Fuzzy group a set of rows with the similarity of 0.8I have selected certain rows (1 column) from a table, sorted the rows and then Fuzzy grouped them. When I execute the package it fails in the Fuzzy group step with the error '[Fuzzy Grouping Inner Data Flow : SSIS.Pipeline] Error: "component "Fuzzy Lookup" (45)" failed validation and returned validation status "VS_ISBROKEN".' and [Fuzzy Grouping [456]] Error: A Fuzzy Grouping transformation pipeline error occurred and returned error code 0x8000FFFF: "An unexpected error occurred.".I changed the MaxMemoryUsage and BufferTempStoragePath properties to see if that helps but it does not. Can anyone help me with this?Thanks in advance,Haarish. |
|
|
Haarish
Starting Member
30 Posts |
Posted - 2009-11-29 : 23:21:25
|
| Hi All,I seemed to have solved the mentioned issue. I guess the issue was with the 'ntext' to 'varchar' conversions since Fuzzy Grouping does not accept 'ntext'. But, the fuzzy grouping now seems to be executing forever. I started a package of Thursday (11/26/2009) with a dataset size of 13200 and it is still executing with the progress tab indicating that the Fuzzy Grouping task has not completed 1% as yet. Are there are parameters that I need to set before executing the package?Thanks in advance,Haarish. |
 |
|
|
|
|
|
SSIS Fuzzy Grouping