Automatic flat file

[Harish]

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

[Harry]

Yeah its real easy with DTS and VB Script. You can use the getdate() function and then use string conversions to rename the file. SQL BOL has some pretty good examples.


------------
Harish at 8/20/01 4:04:23 PM

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