If I understand the question correctly, why not store the mapping information in a configuration file and read it from there.
Basically you would have two pieces of information for each element:
- target column number for an element
- source column number for an element
For example first name would have 2 as target and 4 as source
To use a configuration file you can use
ConfigurationManager.AppSettings [
^].
The example line could look something like
account(CInt(appSettings("FirstName_Target"))) = (currentrow(CInt(appSettings("FirstName_Source"))))
taken that the appSetting is defined properly as in the example in MSDN.