I did not agree,

because BCP creates an empty file, even it it reports the error.

I try to execute in a cmd Shell:

bcp "SELECT EmployeeName FROM #Employee WHERE UniqueId <= 7" queryout "C:\Exports\data.csv" -c -T

and bcp created an empty file.