Hi All, Fuzzy Grouping is not working with SSIS 2008 standard edition when deployed to the local machine, it works only when run manually. The Error I am getting is DTS_E_PRODUCTLEVETOLOW Please let me know if I am missing any thing. Thanks in advance. Tinku

Fuzzy Grouping is ONLY available on Enterprise version look at this : http://www.microsoft.com/sqlserver/2008/en/us/editions-compare.aspxhttp://www.rad.pasfu.com

Is it on the same machine?Arthur My Blog

Hi Reza, Thanks for the quick replay. Is there any other way we could do Fuzz Grouping using T-SQL code. Thanks Tinku

I hadn't such experience before, but this article talks about Fuzzy grouping with t-sql: http://www.sqlservercentral.com/articles/Fuzzy+Match/65702/http://www.rad.pasfu.com

But This is not solving my purpose. This is doing a lookup to a different table. In my case I have only one table and I need a Fuzzy Grouping funtionality. If Any came across sub query please let me know. Anyways thanks a lot for the help Reza.

the link I suggested do both Fuzzy lookup and Grouping, you just need to implement Grouping section of it and you can implement it on single table with the t-sql script proposed there.http://www.rad.pasfu.com

Hi Reza Can you please point me to the Grouping section in the link?