I have an SQL Server Agent job running every day at 9am to run a query and using the Advanced tab in the specific step to run the query I send the output of the query to a CSV file. However, when checking the CSV file, only half of the results of the query display.
I'm using SQL server 2008 r2 and I save it to a CSV file on the network and then open it with Excel 2007 on my Windows 7 professional PC.
When I run the query itself outside of the job and save the results to a CSV file, the whole results show.
Any help greatly appreciated.