Problem in using Fuzzy Lookup with ms access tables.

Question

Problem in using Fuzzy Lookup with ms access tables.

Mr.Sahand

Old Hand

Points: 391
More actions
September 13, 2014 at 5:17 am

#290721

Hi All,
Has anyone used Fuzzy Lookup with ms access tables here?
I am tring to connect two Access tables as the source and lookup using Fuzzy Lookup. After choosing the reference table when I go to Columns tab, Input and Lookup Columns are empty. I have no problem in using the component with sql tables.
Any kind help highly appreciated.

Viewing 6 posts - 1 through 5 (of 5 total)

You must be logged in to reply to this topic. Login to reply

Eirikur Eiriksson SSC Guru Points: 182911 More actions · Answer 1

Mr.Sahand (9/13/2014)
Hi All,
Has anyone used Fuzzy Lookup with ms access tables here?
I am tring to connect two Access tables as the source and lookup using Fuzzy Lookup. After choosing the reference table when I go to Columns tab, Input and Lookup Columns are empty. I have no problem in using the component with sql tables.
Any kind help highly appreciated.

Quick questions:

1. Which version of SQL/SSIS are you using?

2. Do you have the option of importing the tables into an SQL Server database and use if from there?

The Fuzzy components, Lookup and Grouping/Matching are designed for the SQL Server database environment, haven't checked but I'm not even certain they will work without one.

😎

Mr.Sahand Old Hand Points: 391 More actions · Answer 2

We are using SSIS 2012. No we don't have a plan to dump data in SQL.

I know that it can be used in MS Excel.

http://oakdome.com/programming/SSIS_FuzzyLookup.php

Eirikur Eiriksson SSC Guru Points: 182911 More actions · Answer 3

Mr.Sahand (9/13/2014)
We are using SSIS 2012. No we don't have a plan to dump data in SQL.
I know that it can be used in MS Excel.
http://oakdome.com/programming/SSIS_FuzzyLookup.php

Almost any consumable data source can be used, otherwise it would be kind of useless, it is the reference that should reside in an SQL Server database. The component tokenizes the reference data, builds and fills buckets (matching index) and so on, don't think it is applicable on other than SQL Server.

😎

Mr.Sahand Old Hand Points: 391 More actions · Answer 4

Thanks. MSDn says the ref can only be SQL table. Does not it suck??!!

Eirikur Eiriksson SSC Guru Points: 182911 More actions · Answer 5

Mr.Sahand (9/13/2014)
Thanks. MSDn says the ref can only be SQL table. Does not it suck??!!

Feel your pain mate, and be prepared, this may not be your last stumbling block using the Fuzzy components. I find the theory (white paper is available on Microsoft web site) brilliant but the implementation appalling.

😎