I just watched this short YouTube clip on Google Refine.
In the past I’ve used MS Excel to do similar refinement and transformation but that last bit where it allows you to not only see the steps you took as a command list but apply it to a new set of data has my vote.
This is how SSIS should work http://www.youtube.com/watch?v=45EnWK-fE9k
life is Foyn 