In trying to make some changes to a file extract (we are pulling a text file
from another domain into the one our SQL server is in, and then loading a
database from it), we will have the need to "bind" the sets of text files
together.
In other words, for me to know which orderfile goes with which credit file
and shipment files, they'll all have the date appended to the files.
The way it is now, we get:
orderfile.txt which would be named orderfile20030731.txt in the proposed
changes.
tomorrows would be named orderfile20030801.txt and so on.
The other text files would be named in a corresponding manner, so that a
load of creditfile0731 isn't mixed with an orderfile of 0801.
I need to put a step into our existing DTS jobs to take the file, no matter
what the name is, and to rename it (or copy it) to our old filename and have
it be input to the DTS job. Either that, or make the DTS job pick up the
appropriate name.
To complicate matters, we run one database server on monday-wednesday &
friday, and another on tuesday-thursday-saturday.
Is there a way to do this in VBscript from within the DTS job? If so, how?
Any advice appreciated.
Thanks,
Steve