You need to place a derived column transformation between your source and your Destination Containers.

Here is a tutorial on how to use the derived column transformation

http://sqlblog.com/blogs/andy_leonard/archive/2009/02/04/ssis-expression-language-and-the-derived-column-transformation.aspx