My blog has moved to sqlblogcasts.com/blogs/simons
The full version of this post can be found here., http://sqlblogcasts.com/blogs/simons/SSIS Address clean up in 10 steps
The new RSS feed is here
So just started playing with SSIS to convert a legacy app. Data is in a bad state, lots of duplicates especially addresses.
So what do you do, firstly this data is in Access, secured with a workgroup file.
... To read the complete version of this post go here, http://sqlblogcasts.com/blogs/simons/SSIS Address clean up in 10 steps