Query results in ANSI

[Dimitrie1]

I need to store the results of a query in a fixed length ANSI text file. I'm using SQL2005.
Any ideas ?

I know I can do a SaveAs on the file but I need to run this daily for 6 months and am trying to automate as much as possible.

 

[NoCoolHandle]

Simply create a jobstep and save the query results to a text file.

The default seems to be a fixed width column.

 

[Dimitrie1]

what is a jobstep?

I did determine that I can choose ANSI when saving but I'm trying to automate as much as possible

 

[NoCoolHandle]

JobSteps are part of what the "SqlAgent" does.
It allows you to create multiple automated jobs that run based on a schedule. Usually it is used to run automated backups and scheduled maintanence jobs. Howerver it is also usefull for what you are describing also.

In Management Studio, it is the thing at the bottom.

 

[Dimitrie1]

oh okay - you were referring to scheduled jobs.

thanks