40 Fuzzy Lookup Transformation in SSIS

[@ladhkay]

Great videos, keep it up!

[@learnssis]

Thank you for your support.

[@geeseeoh]

Hi Aqil, can you join results of fuzzy matching and then do another fuzzy grouping? Like for a dataset, first grouping is address, then next is last name and finally social security. These creates 3 groupings. And how do you combine records that are linked together?

[@abusaidsarkar468]

can you help me how to used not in two component in ssis like select * from dbo.tblStudent where intStudentId not in(select intStudentId from dbo.tblLibary )

[@learnssis]

Sorry for replying so late, was a bit busy. You can use Merge Join component where you can use Left Join, so it will return all records from left source and matching records from right source. For non matched records from right source you will get a NULL value, so may be in a derived column transformation you can replace a NULL with some different value and then in Condition Split transformation based on the data returned you can decide if you want to move the matched records to one table and non matched records to another table.

[@viswanathponne]

hi aqil,you are doing good job.

[@learnssis]

Thank you so much for your comment.

[@techbroaniletl8226]

Hi bro can you explain script task regarding particular file need to pic up

[@learnssis]

Can you explain in detail meaning particular file pic up ? Do you want to get the file path of a file ?

[@anilprnctube]

How did u get the similarity, confident columns?

[@learnssis]

Hi Anil, these columns are returned by Fuzzy Lookup Transformation itself.

[@TheAnkitatri]

Hi sir ,while creating package through ssis not able to run .. plz help me out with that as i m trying whole day ..especially in colum tab

[@learnssis]

Hi Ankita, what error you are getting while running the package ?

[@muktabansal2300]

Hi, Your videos are very good, very well explained. Could you please upload video about the difference between fuzzy lookup and fuzzy grouping, example of fuzzy grouping. Thanks

[@learnssis]

Thanks Mukta for your comment, I will surely upload the video about Fuzzy grouping.

[@learnssis]

Hi Mukta, I have uploaded a new video on fuzzy grouping. kzbin.info/www/bejne/jmK9mYKJl6pmpdE I hope you will like it.

[@muktabansal2300]

Thanks.. really appreciate the help

[@deepikaswarnkar9486]

I am subscribe your channel

[@SureshBabu-rv9mb]

Nice Videos. your videos are too good. Can you send me all videos source files. It will be very useful. Thanks

[@learnssis]

Hi you can get all the videos here kzbin.info/www/bejne/opzYp6mXhNOnmJY

[@maihuire11]

Error with Data of 20 million.

[@learnssis]

What error are you getting ?

[@maihuire11]

@@learnssis thanks for answering me. This is the error: Error: 2021-12-03 14:36:03.08 Code: 0xC0047022 Source: BUSQUEDA DIFUSA SSIS.Pipeline Description: SSIS Error Code DTS_E_PROCESSINPUTFAILED. The ProcessInput method on component "FUZZY LKP" (2) failed with error code 0x8000FFFF while processing input "Entrada de busqueda aproximada" (16). The identified component returned an error from the ProcessInput method. The error is specific to the component, but the error is fatal and will cause the Data Flow task to stop running. There may be error messages posted before this with more information about the failure.

[@learnssis]

@@maihuire11 I think this error is related to Memory, because data is huge, thus you would need more memory to process it.

[@abusaidsarkar468]

Good

[@learnssis]

Thanks for your comment.

[@abusaidsarkar468]

can you help me how to used not in query in ssis like select * from dbo.tblStudent where intStudentId not in(select intStudentId from dbo.tblLibary )