Using SQL Server 2000.
Running the following DTSRUN line in OPCON job:
DTSRUN /N"XML Data Load 1" /E /SDEV1 /L\\OPCONJOBS\OUTPUT\XML01.out

The file XML01.out is growing larger and larger due to the DTSRUN output
getting appended to this file rather than overwriting it.

1. Is there a DTSRUN option to specify that the output file should be
overwritten each time DTSRUN is executed?
2. Is is possible to keep an archive of the old file for 1 day before
overwriting it?

I am not a VB programmer so any VB solutions need to be simple and well
explained.

Thanks,

Simply copy the file after the package has been processed and in a
separate job step to some other area. DTS will recreate the next time
the package runs. You could move and rename.

"khan_salim" <khansalim (AT) discussions (DOT) microsoft.com> wrote

I need this solution to copy the file to another directory and rename it to
be automated. Do you know of an OPCON job or a step I can put in my DTSRUN
line to accomplish this copy and move operation for a file. I am aware that
if the file is removed DTS will create the new file that I need. I just do
not know how to automate this process of moving the file.

"Allan Mitchell" wrote:

I do not know anything about OPCON but I am sure you can call a piece of
Active X Script that does the move and all OPCON does is call it.



"khan_salim" <khansalim (AT) discussions (DOT) microsoft.com> wrote

It's the 'piece of Active X Script' that I am seeking. If I have code to do
this then my question is answered. Since I am not a VB programmer I am
seeking help/ideas on the specific code I can put in an Active X script if
this is the only solution.

Thanks

"Allan Mitchell" wrote:

Have a look here

http://www.tutorial-web.com/asp/fso/...?property=Move

"khan_salim" <khansalim (AT) discussions (DOT) microsoft.com> wrote