Hello, I am looking for code to help create a .bat file for Windows that does the following: count = Number of files in a folder if count == 0, exit else FOR all files in the folder set ORIGINALFILENAME = filename of file1 rename file1 to (hardcoded) ABC.dat run sqlloader on ABC.dat rename ABC.dat to ORIGINALFILENAME.dat move ORIGINALFILENAME.dat to another folder next file end Any assistance if very much appreciated!

Also, I have the command to run sqlloader. But, not the code around it.

@echo off setLocal EnableDelayedExpansion for /f "tokens=* delims= " %%a in ('dir/b/a-d *.dat') do ( ren %%a ABC.dat echo do the sql on ABC.dat ren ABC.dat %%a echo move %%s d:\some\place ) ===================================== If at first you don't succeed, you're about average. M2

CORRECTION ::== @echo off setLocal EnableDelayedExpansion for /f "tokens=* delims= " %%a in ('dir/b/a-d *.dat') do ( ren %%a ABC.dat echo do the sql on ABC.dat ren ABC.dat %%a echo move %%a d:\some\place ) ::== ===================================== If at first you don't succeed, you're about average. M2

Thank you very, very much! That is exactly what was needed. Working fine.