I have seen a number of hacks to try to get the bcp utility to export column names along with the data. If all I am doing is dumping a table to a text file what is the most straightforward method to have bcp add the column headers?

You should be able to solve this problem with one cte view and one batch file containing the bcp code. First create the view. Since, its relatively straight forward, I did not create a temp table, normally I do