HeLp plZ Save a daily query result as Csv Into New File

[Likethatjazz]

Hi all,

i use mssql 2005

I have a doubt, how to create a schedule for a query to run every day,the result should be saved every time the query runs, into a new file

For the moment I use SQL Server Agent to do this daily,
with a jobtask and my query inserted. The output has no extension
he doesn’t seem to make a new file every time, just replaces it.

Also the outputtfile should be automatically saved/exported as an Csv file.If thats possible...
These are my first steps with mssql server.
Im loving it, but now Im stuck since a few days.

Greetz Kristof