yes its just going from 1 column in flat file to 1 column in a table just with the new fix up data.
so say its security name in the flat file and there is a column in table called security name and thats where it will end up
OK, great - so we're just dealing with a piece of text.
But imagine a single table full of these text chunks - not that useful, surely? So...
Will the target table have other stuff in it?
If so, how will you know which target row to update, based on the source data?
Help us to help you. For better, quicker and more-focused answers to your questions, consider following the advice in this
If the answer to your question can be found with a brief Google search, please perform the search yourself, rather than expecting one of the SSC members to do it for you.
Please surround any code or links you post with the appropriate IFCode formatting tags. It helps readability a lot.