Automate Importing Files with Variable File Names

Toad Data Point
1

Hi–

I would like to build an automation script that does the following:

  1. Imports files from a specified folder, the file names of which will vary but follow the same basic convention (i.e. blah_mmddyy.txt where the date changes by day)

  2. Copies the imported file to another folder

  3. Deletes the original file

I know importing, copying, and deleting are all possible but am not sure if this can be done when the file name(s) will not always be the same.

Thank you!!

2

The import templates require that the file have a specific name. To accomplish what you listed below you would need to write a DOS script that renames the files to the name your import template is using. This can be used in the Run Activity. Then use the import activity followed by Copy File and Delete Files activities.

Debbie