-
How to automate Date & Time stamp in a FILE Name created via DTS
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!
-
How to automate Date & Time stamp in a FILE Name created via DTS (reply)
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!
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
|