I have set up a job within SSMS 2008 to run everyday where it executes queries against two tables and stores the results in .csv text files in a folder. It works fine but I would like the files to be comma delimited text files and as it is now it is storing data with spaces between the columns and this creates unnecessary increase in size.. I went to tool/options etc and set the sql query text file format to comma delimited and it works fine when I run a manual query and select to save the results but not within the actual job. Any suggestions In fact if I could get the results from both queries to store into one text file only that would be even better