Try to avoid the addition of the column into the files. Whatever approach you apply for that operation, it will be slow.

Doing the same in the db engine is pretty smoother.

Idea: Can you do something like after insertion of data from a text file into a table, you do another operation which will add/update that column you're adding to the text files previously.

Regards,

Igor