I have 3 data sources. Students, Teachers, and Non-Teachers (all the data pulled is in the same layout and aliased the same). Students and Teachers come from the same database but the "Non" comes from a different. If have been working on this for almost a day trying to get the output to a flat file (csv). The hang up is, the Student and Teachers sources have "user_id" of integer - (DT_I4) and the Non-Teachers user_id is varchar(12) - DT_STR example Exxxxxxx. I have attempted join things using a Derived Column, Merge, Merge Join, etc. I either get an error due to datatype or I get rows with ,,,,,. One thing I would like to add...some Teachers and Non-Teachers exist in both data sources. In this case, I want to use the Teachers source in the destination and disregard the Non-Teacher data. Any insight would be gratefully accepted. Thanks.