Have a look at VBScript's FileSystemObject object--that's got all sorts of
methods for traversing directories & doing things to files.  If you need to
do this in VB proper, set a reference to the scripting runtime (scrrun.dll).

Cheers,

-Roy

-----Original Message-----
From: Karen Martin [mailto:kmartin@a...]
Sent: Wednesday, March 28, 2001 3:54 AM
To: professional vb
Subject: [pro_vb] Finding, renaming & feeding files to DTS Packages for
SQL Server


Hello.

I have been given a task to do and I would appreciate some pointers, i.e.
what is the best way forward.
Initially, I need to create a vb program that finds files with specific
extensions (eg. .txt) within a specific directory.  For each file found, it
will need to be renamed (but still keeping the same extension) and then, fed
into a DTS package that I've already created and is up and running.  This
DTS package then needs to be executed.  Upon completion, the next file found
needs to go through the same process.
When I've a program that is working fine, I'll then to incorporate this
program into the DTS package (as VBScript).
Can anyone help?



Karen Martin
Payment Systems Technical Specialist
Alphatec Software

Telephone: 01908 363936
Email: kmartin@a...