You can use the DATA= command line parameter instead of INFILE= and if the file follows some naming convention, you could use the command:

for %f in ( *.* ) do sqlldr userid=user/pw control=control.ctl data=%f

to load it (where *.* of course is a wildcard that id's your specific file).

followup to comment one

Sorry it was not clear.

Instead of

LOAD DATA
INFILE 'c:\bsp\stmt.txt'
APPEND
INTO TABLE tblMailboxData
....

You will have

LOAD DATA
APPEND
INTO TABLE tblMailboxData
....

(no infile statment). Instead, you will use DATA= on the command line to sqlldr:

sqlldr userid=x/y control=c.ctl DATA=c:\bsp\stmt.txt


Now, if your filename is always CC*.001 and you want to load ALL of the CC*.001 files in a directory, the Windows command:


for %f in ( CC*.001 ) do sqlldr userid=user/pw control=control.ctl data=%f

will do that for you.