I am outputting a text file using bcp to a customer and my output writes a blank line at the end of the file. The customer cannot accept any blank lines at the beginning or end of file. The bcp command is reading from a ## table and I have checked to see if there are any blank rows in the table. There are no blank rows.
Does anyone know of a way to make sure no blank lines appear at the end of a file.
This is my bcp statement
SELECT @bcpCmdStr = 'bcp "Select * From ##tmpGLBalExportTab " queryout "' + @bcpOutFile + '" -S ' + @sqlSrv + ' -c -T -t "\t"'
Thanks in advance