MS SQL Server - SSIS Globalization

You are viewing an archived Text-only version of the thread. To view this thread in it's original format and/or if you want to reply to this thread please [click here]

Author

SSIS Globalization

dagda1

2006-02-06, 7:23 am

Hi all,

Does anyone have any advise about how to handle the following
Integration services scenario:

We are merging lots of CSV from different surveys about tools.
Unfortunately the surveys have a text field in different countries
that might read:

Which too do you own?

Obviously in English this could be 'Drill' or in Spanish something else
or in Swiss etc. etc.

Is there anything that comes out of the box that can handle this or how
on earth do I do fuzzy lookups or lookups in this scenario.

I am very confused.

Thanks

Paul

Sponsored Links