I would like to load files with powershell as my environment is windows so can't do it in shell....
into table name
FIELDS TERMINATED by '!'
OPTIONALLY ENCLOSED by '"'
I have around 27K files and this is everyday operation... I need a powershell to loop through files in put them in INFILE
... after load is done it will move them at archive folder.... or it will load the file name at the end of each record... or load the files name in another table ....
thanks for help...