Kind of new to DTS.
I want to write out an "new" excel file each time a DTS package runs.
I create a DTS package where I have a script file, a database connection,
excel connection and a transformation which pulls data out of a table and
dumps it into an excel file.

My script file is modifying the Excel connection and changing the name of
the "target excel file".

My question. Can I use a script file to create a "empty" excel file with a
"tab" in the worksheet with the name of "Fred", such that when my script file
changes the name of the "target file" in the excel connection, the
transformation will occur as desired. Is this the most appropriate way to
deal with this?

Thanks in advance for your assistance!!!