Trim all column when import data using SSIS

The approach here is to use Script Component.

http://www.proactivespeaks.com/2012/04/02/ssis-transform-all-string-columns-in-a-data-flow-stream/

And here is the second way

http://microsoft-ssis.blogspot.com/2010/12/do-something-for-all-columns-in-your.html