You could do so with a script task, but generic processes such as this can be hard to debug. Alternatively, there are third-party tools that allow you to build dynamic data flows, although I've never tried that particular function.