I have to create an ascii file which name format is like vyymmdd.txt
What would be the best way to do this?
I have used DTS package to do this but file neme must change every day.
rgds
KariHi Kari
could you specify from where you create the file and what for?|||Hi,
I have a sqlserver table and I would like to generate each day a text file from that.
rgds
Kari|||Is this what you're looking for?!
select 'v' + convert(char(6), getdate(),12)+'.txt'
Regards,
Clifford Dibble
No comments:
Post a Comment