Does anyone know if there's a way to copy/paste, the "Flat File Layout" settings, onto multiple .txt files with the same fields?
I find it somewhat tedious and time-consuming to update the "Flat File Layout" settings, every time I have to insert a text file to read as a flat file.
Any helpful suggestions would be great!!
@wbroughton7 If you want to read all the text files with the same schema then you can use the dynamic input tool, once you setup the positions it will apply the same setting to the next file and parse according to the field length
There is an option at the bottom of that Flat file settings window to use field settings from file. You will need to figure out how to save the settings as a file, but once you have, then just apply that file to each.
If that is still too much to configure, then a batch macro or dynamic input is going to be best.