Pretty simple so far. The issue I have is that there could be combinations of the same segments, and I need to create a driver table that contains all the possibilities. This table will be used to actually populate the different tables that support our application.

You may want to download the white paper and code samples from my conference session entitled "I Never Met a Data I didn't Like". You will find it on the tools and utilities page of my web site. There are a couple of examples that use the field mapping concept do do data migration and export to a text file. Although not exactly the same thing that you are doing, they are similar enough that you may get some good information from them.