I have a source table that contains records to be transformed into a second table. However, I need to do specific transformations based on the value in one column of the source: ie. if value = 1 then a certain set of lookups etc if value = 2 then a another set of lookups etc What is the best way to accomplish this with SSIS?

use Conditional Split Transformation, write your expression there, and connect each output to next transformation/destination you want.http://www.rad.pasfu.com

Thanks alot, exactly what I was looking for. Thanks.