Dynamic Column Mapping

[Bill]

Hi,
I need to take out records from one table and insert it
into another identical table via a C# application.Is there
a way to dynamically determine the corresponding columns
of the two tables ?

If I use an XML file to map the corresponding columns of
the two tables, how do I check the mapping file
dynamically before data insertion ?

Any help is appreciated.

Thank You

 

[Kathleen Dollard]

Bill,

Could you clarify what you mean by "check mapping file dynamically"?

 

[Bill]

By dynamic mapping, I meant that before the records are
transferred from one table to the other(source to target),
the xml file which will have the field names of the two
tables mapped, is to be checked so that while formulating
the "insert into" statement, the column names of the
target table should match that of the source table.