1. I want to create a flat file from sql server on every night
which will contain data from particular table of that paticular date.
2. I wanna put the file in the particular folder.
3. I wanna give the file name like 'ALT-yyyyddmmhhmmss'
where 'ALT' is some constant and 'yyyy' is year,'dd','mo','hh','m m','ss'
is the day,month,hours,minutes,seconds of the day respectively. So that we can find from the name of the file when it is created.
4.Please suggest me how to go for that.

Thanks,
Harish