Does Fuzzy Lookup work with Oracle ?

Sorry, this might be an obvious question, but I can not find anything in the documentation/forum.

I want to use a Fuzzy Lookup between 2 Oracle tables.

I select the Reference Table.

I then switch to the Columns tab, but the "Available Input Columns" and "Available Lookup Columns" lists are always empty.

I have experimented quite a bit, but to no avail. I noticed this on the Reference Table tabpage : "The table maintenance feature requires the installation of a trigger on the reference table". My guess would be that SSIS does not support Oracle for this, but I am not able to find anything in the documentation that it doesn't.

Any answer/pointer greatly appreciated.

Thanks

Jan Vandepitte

Haven't tried it against Oracle, but my first question would be whether you have permission to create tables and triggers in the db.|||

Hi Jan,

The Fuzzy Lookup and Fuzzy Grouping components are SQL Server only.

I'm sure the answer is also in books online somewhere, but the SSIS Connectivity Wiki has a simple table that shows the data provider options for each of our components.

Hope that helps!

~Matt