SQL Loader: writing batch file (windows) for processing multiple data file

Question

I want to process all the .CSV in files (data files) in specific folder. My problem is how can i pass this file name to sql loader as every time it would be different file name.

I want to have all this stuff in single batch file so that i can schedule it whenever i wish.

Can anyone help me out pls?

Thanks in advance....

Mehul

user330315 · Accepted Answer · 2011-04-13 08:35:44Z

4

Assuming for each .csv file there is a corresponding .ctl (control file) the following should work:

for %%i in (*.csv) do ( 
   sqlldr data=%%i control=%%~ni.ctl log=%%~ni.log
)

This assumes the files are in the current directory. You might want to add the approriate cd commands before iterating over the input files.

answered Apr 13, 2011 at 8:35

user330315

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

SQL Loader: writing batch file (windows) for processing multiple data file

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related