"Steve Chatham" <schatham@yahoo.com> wrote in message
news:#05Vr#qVDHA.3088@tk2msftngp13.phx.gbl...
> 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
>
>