How to do 2 tables lookup with another table. No match out put should go in flat file. so we will get 2 flat files. for 2 tables. What should be in control flow? what will be in data flow.and i should use only one variable for both the tables for flat files.

Thinking you can create a view (if possible) and then see: http://mcaf.ee/kb9qoArthur My Blog

Your requirements are not very clear, but based on what I have understood here is what you can do... Control flow should be just a data flow task. In the data flow task you have the source(probably oledb source) and then 2 lookup for each of the 2 tables one after the other. The error output from the lookups can go to the corresponding flat files.

could you explain more about your question, sample input rows and sample requested results will be helpfull. As I understood from your description you have only two simple lookup component.explain more pleasehttp://www.rad.pasfu.com

Your requirements are not very clear, but based on what I have understood here is what you can do... Control flow should be just a data flow task. In the data flow task you have the source(probably oledb source) and then 2 lookup for each of the 2 tables one after the other. The error output from the lookups can go to the corresponding flat files.