Hi!!!
i have two SQL data files which has same fields same data if it has any mismatching data(some missing data or different data) in that fields then I want to store mismatching data in another field “is it is possible to store the data in different field? 
” if it is possible then how i do it? please give me a solution in some steps!!!
Regards,
Thilagavathi
Simple way to do this to iterate both the tables one side the other check all column if match dont do anything if not then update that row using Build data table.
Thank You!!! for your reply and i have doubt in iterating that two tables please give me any reference for that activity
Regards
Thilagavathi
Use a for loop in which use Outer datatable,
Use one more for loop inside the above and use If condition inside for the inner for loop.