SQL Server Agent job running query only sends half of the results to file

Question

Post reply

SQL Server Agent job running query only sends half of the results to file

sqlrd22

SSCrazy

Points: 2255
More actions
October 10, 2012 at 9:28 am

#268405

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.

Viewing 6 posts - 1 through 5 (of 5 total)

You must be logged in to reply to this topic. Login to reply

Chrissy321 SSCoach Points: 15763 More actions · Answer 1

This thread looks promising as a solution....

http://social.msdn.microsoft.com/Forums/en-AU/transactsql/thread/ec9348c5-acbc-4ca7-8793-322847511460

http://msdn.microsoft.com/en-us/library/ms186238.aspx

sqlrd22 SSCrazy Points: 2255 More actions · Answer 2

sqlrd22

SSCrazy

Points: 2255

October 10, 2012 at 2:02 pm

#1547800

Thanks, I'll give it a go tomorrow.

sqlrd22 SSCrazy Points: 2255 More actions · Answer 3

Chrissy321 (10/10/2012)

This thread looks promising as a solution....

http://social.msdn.microsoft.com/Forums/en-AU/transactsql/thread/ec9348c5-acbc-4ca7-8793-322847511460

http://msdn.microsoft.com/en-us/library/ms186238.aspx%5B/quote%5D

Sadly, this didn't work for me.

VastSQL SSC-Dedicated Points: 36097 More actions · Answer 4

Have to specified any size limit to the output file??

sqlrd22 SSCrazy Points: 2255 More actions · Answer 5

I don't really understand the question. Do I have to specify a limit? No. I did try the set textsize option but this did not change the output for me.