difference between the fuzzy lookup and fuzzy grouping in ssis

Dear Friends,

i think fuzzy lookup

COMPARES WHAT WE ARE MAPING THE COLUMNS WITH SPELLING (IT WILL REJECT ATLEAST 1 LETTER IS DIFFRENT IN ANY RECORD MAPPED COLUMN) EX: RAVI != REVI

what is fuzzy grouping ? please explain

regards

koti

Fuzzy grouping lets you find patterns in your data that could represent duplicated data. i.e., it could match address data like "1234 Main St." to "1234 Main Street" and push these into one record. Fuzzy lookup helps you to clean dirty data by comparing your input with an outside source.

|||

Koti,

I'm just noticing your other threads here... If you have any further questions about what a component does, you should first try to find out about it through the books on-line feature of sql. Most of these components you have asked about have rather good documentation...

Please, look for the documentation BEFORE posting questions like this...

Thanks for your time.

Eric

Developing new Task in SSIS

Hi All:

For making a custom Task in SSIS, is it possible to reuse the existing code base? For e.g. If i need to append some functionalities to LookUp Transform. Can I inherit the lookUp transform class?

Thanks,

Vipul

Vipul123 wrote:

Hi All:

For making a custom Task in SSIS, is it possible to reuse the existing code base? For e.g. If i need to append some functionalities to LookUp Transform. Can I inherit the lookUp transform class?

Thanks,

Vipul

No. Unfortunately not.

-Jamie

developing new task

Hi

Can i inherit a existing task to a new custom class to add functionality to custom class.

for eg: Inherit lookup transfor which is already present in SSIS to add some funstionality into it.

Thanks

Vipul

https://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=796926&SiteID=1