You can make an Integration Services package and schedule that with a SQL Server Agent job.

A tutorial:

Export Data to Flat File using SSIS Package

If you have zero experience with SSIS, you could run the SQL Server Import/Export wizard to export to the flat file. At the end of the wizard you have an option to save the resulting package. Then you can schedule that package in the job.