Char Dec Oct Hex
(sub) 26 0032 0x1a
For some reason COPY, yes the DOS COPY command, adds 0x1a to the end of a multiple file COPY command. You can see the SUB at the end of a file in NOTEPAD 2.
One way to get a “header row” or a list of column names from a table for a bcp out is to append a header file and the data file.
The only way I’ve found is to use COPY. If we simply tell COPY the files are all BINARY, it won’t add the 0x1a to the end.
COPY /B File1+File2 File2