Great! Thanks for your reponse! I will look into it!

Also when this project goes live this data will be coming from flat files. How is the best way to combine it and put it in a single table...

Great idea! I will try it!

Thanks again!

jg.. Thanks for your reponse! I was wondering if I should use a merge transformation with a right or left join, but it only allows you to combine...

Thanks for your answers!!! I am using the union all transformation. No code just the SSIS tool. I want to combine selected columns from the three tables...