I'm sure it must possible to adjust the columns for a flat file output based on the input, but so far have not found the right tools.
I have to convert quite a few tables to flat files, where the input columns have not been safely specified yet.
The tables are still being changed.
e.g. I have a table with columns A,B,C. Columns D,E,F... could be added later, maybe B or C will even be removed or renamed.
I have to transfer all data from the table except for column A to a flat file.
I find it annoying having to adjust the columns manually every time. Would be extreemly thankful for your advice.
View Complete Post