For a data warehouse project, I would like to use DTS but I need to handle data de-duplication and address normalization. Does anyone have experience w/ any 3rd party tools that could integrate with DTS to provide that functionality, or with writing custom code to implement it directly within DTS? Thanks.

DTS CURRENTLY does not have this. If you want it then send a mail to
sqlwish (AT) microsoft (DOT) com.

We use a 3rd party ActiveX control embedded into VB to do this kind of thing
currently.

--

----------------------------

Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
www.allisonmitchell.com - Expert SQL Server Consultancy.
www.SQLDTS.com - The site for all your DTS needs.
I support PASS - the definitive, global community
for SQL Server professionals - http://www.sqlpass.org


"Anonymous" <anonymous (AT) discussions (DOT) microsoft.com> wrote

w/ any 3rd party tools that could integrate with DTS to provide that
functionality, or with writing custom code to implement it directly within
DTS? Thanks.