I have a SQL CmdExec Job set up to run a query however the output data contains headers, job information and total numbers of returned rows as part of the output file and I am trying to figure out how to exclude this, this project calls for only the raw data to be returned.

Based on other suggestions I've tried adding **"sqlcmd -Q set nocount on;   "** before my query as well as **"-S localhost -D master -o"** at the end of the query but the extra data remains in the results.

Any suggestions are greatly appreciated.