Re: how to trans similar string ?

#1

There is nothing in DTS that can do this. You would have to write a
transformation script or your own custom transform that implemented this
logic, perhaps using regular expressions, but I suspect this would be hard
work.

--
Darren Green
http://www.sqldts.com

"x" <xiaopeng (AT) creditbeijing (DOT) com.cn> wrote

Quote:

I want to trans some similar string in oltp system by using dts?
for example:
ms
microsoft
microsoft corp.
m*s*
....
all trans to microsoft
oracle
ora
oracle corp.
all trans to oracle

........

how to do that?how to get similar percent?

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Re: how to trans similar string ?

microsoft.public.sqlserver.dts microsoft.public.sqlserver.dts

Re: how to trans similar string ? - 07-14-2004 , 03:10 AM