Hi, Is there any way to give the destination file a new file name (i.e. one
based on current date/time) in the DTS package or is it best to just write a
DOS batch file to copy the file to a new filename after the package is run?
Thanks!

Diana,

One way to handle this would be to set the destination file name via a
global variable and a dynamic properties task. Then in the job step use
the command tokens to set the date and time.
DTSRun /S "(local)" /N "Pkg11" /A
TargetFile":"8"="[DATE][TIME]Results.txt" /W "0" /E

See the BOL for sp_add_jobstep and go to the @command parameter. All the
tokens are defined there.

Another way would be to build the time string in an activex script task,
assign it to a global variable and then assign the file name with a
dynamic properties task.

Norman

get DTS Package Search at http://www.gerasus.com/

Diana_R wrote:

What about using something like in this article

http://www.sqldts.com/default.aspx?200



--


Allan Mitchell
Konesans Ltd
T +44 7966 476 572
F +44 2071 008 479
http://www.konesans.com



"Diana_R" <DianaR (AT) discussions (DOT) microsoft.com> wrote

Hi Norman and Allan,
Thanks for your responses. I tried something similar to what Norman
suggested yesterday afternoon and it seems to be working the way I'd like.
Kindest regards,
Diana

"Allan Mitchell" wrote: