thank you very much for your advice

please follow these bellow steps to Achieve your requirement:

Take a flatfile source for flatfile and OLEDB source for target table

Take a Merge join and make a full outer join between...