Friday, February 24, 2012

generate filename from today

Hi,
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