How to automate Date & Time stamp in a FILE Name created via DTS

[Dhiraj Sharma]

Hi,

I would like to know as to how can I put a Current Date & Time stamp on a FILE NAME automatically which is created by a DTS package.

E.g. I create a file named ABC.TXT daily. How do I get this file to have the current Date stamp so that the file name is ABC121201.TXT without any user intervention.

Thanks for the help!

[dba723]

here is a quick format:

declare @dt_str varchar(8)
select @dt_str=right(convert(char(3),100+month(getdate()) ),2) + right(convert(char(3),100+day(getdate())),2) + right(convert(char(5),10000+year(getdate())),2)

just add the @dt_str value to the string that names your file.

------------
Dhiraj Sharma at 12/13/2001 12:18:29 PM

Hi,

I would like to know as to how can I put a Current Date & Time stamp on a FILE NAME automatically which is created by a DTS package.

E.g. I create a file named ABC.TXT daily. How do I get this file to have the current Date stamp so that the file name is ABC121201.TXT without any user intervention.

Thanks for the help!