I would love to see an automatic trimming transformation. We currently have 14 different ERP systems throughout our company and almost everything we do, when it comes to strings, requires trimming. Although doing it through the derived column task is somewhat easier, it is very time consuming and error proned, if you overlook a column or two.
-BradG
Sorry, meant for this post to go under the "MOST Wanted" post.|||Sounds like an excellent candidate for a custom transform to me :)
-Jamie
