Welcome to PC Teach Me...

Free Computer Training Videos.

Although you do not need to register to access this site. Registering has its benefits. Such as:

  • Access to training material associated with the video you are watching [if applicable]
  • Automatic email updates when new training videos are available.
  • Ask for a training video.
  • Exclusive access to pose questions to me [limited availability as I am doing this for free :-)].
  • Free contribution of your own training topics, this includes referencing your videos outside of PC Teach Me.
  • Its Free!

Member Login

Lost your password?

Not a member yet? Sign Up!

By registering with this blog you are also agreeing to receive email notifications for new posts but you can unsubscribe at anytime.

25426 Registered Users
71 Number Of Articles
Free Video Tutorials (Email) Free Video Tutorials (RSS) Free Video Tutorials (Twitter) Free Video Tutorials (Flickr)

SSIS: Fuzzy Lookup

ssis SSIS: Fuzzy LookupSSIS: Fuzzy Lookups

With the any kind of database import there are always going to be data problems. Why? Well, it generally down to human beings. A computer is logical, a human is not. A computer does what its told, a human does not. So is it no wonder why data that you import which was keyed in by humans has errors? Its understandable, but what can you do about. Lets take a specific example, you have a list of employees sooner or later there are going to be spelling mistakes or typos.

Other problems could be categorising, I could think the “sales” department someone else could think “Internet sales” department. So what do you do when your trying to standardise data? A Lookup transformation task wont cut it because Lookups are searching for exact matches, this is where the fuzzy lookup comes in.

Where SSIS Fuzzy Lookups Come in.

The fuzzy lookup (not to be confused with Lookups) does not “look” for specifics, instead they use pattern matching to best guess a solution. This tool is valuable when coming to produce your data warehouse.

This video shows you how to configure a Fuzzy Lookup in SSIS and what you can do with the results returned. To fully understand Fuzzy Lookups, you must first understand Lookups (see related video). As before, this area warrants over an hour of coverage, so to save time I have produced an example database with a package already created that gives you the ability to play around to see all the different aspects of Fuzzy Lookups.
This video is one of many SSIS tutorials on this site click here for more.

Example SSIS File

To obtain the sample files please click here:

Related Posts

15 Comments

  1. Blaze Neon says
    25 Mar 15 at 6:00am

    Really clear tutorial. Thanks.

  2. William Hebert says
    02 Dec 13 at 2:08pm

    I inherited a Fuzzy Lookup package from an employee who moved on. This was a helpful introduction into what it’s all about. Thank you!

  3. Andie says
    07 Oct 13 at 12:02am

    Thanks a million times for the knowledge you are passing..,
    Any ideas on how to download the sample files, there is no link?

  4. Johnny Agsalog says
    24 Sep 13 at 6:25pm

    In the Example SSIS file, there is no link in the page? Can you send me a link to download the sample file?

  5. kkr141 says
    10 Nov 12 at 3:41am

    Hi, i just started learning SQLBI i am enjoying your videos. thanks for uploading…keep it up with your good work

  6. jamiebarrowtube says
    22 Jul 12 at 3:22am

    Thank you for this, I may end up using this instead of a custom solution I’ve created in SQL using Jaro Winkler function (my solution is too slow when the input is in the thousands of rows). I’m doing something similar to the fuzzy lookup / lookup, and have a few different inputs to match on (ID Number, date of birth, surname, initials), some/all of which could have typos. Hoping SSIS is faster :)

  7. 22 Jul 12 at 3:22am

    [..YouTube..] Thank you for this, I may end up using this instead of a custom solution I’ve created in SQL using Jaro Winkler function (my solution is too slow when the input is in the thousands of rows). I’m doing something similar to the fuzzy lookup / lookup, and have a few different inputs to match on (ID Number, date of birth, surname, initials), some/all of which could have typos. Hoping SSIS is faster :)

  8. niquem says
    18 Apr 12 at 12:26pm

    Oooh Oooh Can I be a groupie too? …… Errr actually ignore that last comment… :)

    Cracking commentaries BTW. Personally Im using these as a refresher after not using SSMS. SSRS and SSIS for nearly a year.

    Good work fella.

  9. niquem says
    18 Apr 12 at 12:26pm

    [..YouTube..] Oooh Oooh Can I be a groupie too? …… Errr actually ignore that last comment… :)

    Cracking commentaries BTW. Personally Im using these as a refresher after not using SSMS. SSRS and SSIS for nearly a year.

    Good work fella.

  10. PCTeachME says
    02 Feb 12 at 11:27am

    Thanks yet again, your becoming quite the comment groupy of my channel ;o)

  11. PCTeachME says
    02 Feb 12 at 11:27am

    [..YouTube..] Thanks yet again, your becoming quite the comment groupy of my channel ;o)

  12. PCTeachME says
    02 Feb 12 at 11:27am

    [..YouTube..] @christosch Thanks yet again, your becoming quite the comment groupy of my channel ;o)

  13. christosch says
    01 Feb 12 at 11:55am

    thanks

  14. christosch says
    01 Feb 12 at 11:55am

    [..YouTube..] thanks

  15. achyuth says
    02 Jun 11 at 9:25am

    Yes, i have really enjoyed it as you said, really sooo interesting explanation. thanks for your effort. hard to get these kind of video. please upload more.

    or create a full length training. will be greatly appreciated.

Leave a Comment

You must be logged in to post a comment.

Valid XHTML 1.0 Transitional website security