ronan.healy (7/30/2014)
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?
If you haven't even tried to resolve your issue, please don't expect the hard-working volunteers here to waste their time providing links to answers which you could easily have found yourself.