Hello all,[:)]
Hope some one throws some light [:)]
my requirement.
1) Daily we get file name 20080424ABC.txt and 20080424ABC_XYZ.txt (date concatinated to the file name ) in to our folder say \\z\files\
2)Now my job which reads "20080424ABC.txt " is with a seq file. I can not hardcode daily that date appended file. Important thing is we may run job at any time i.e daily or once in 2 days or 5 days once.So i may have 5 files since i run the job if am ruunning it after 5 days...my job should process them one by one the sequence is imprtant .
3) I want a logic - how can we parameterise my job and also have tht file name(20080424ABC) to be a field in my job so that we store that name to corresponding row loaded from respective file.
Need a logic to pic a date attached file
Moderators: chulett, rschirm, roy
thanks for the quick reply ,kumar_s wrote:Read all the files in a folder and pass it as parameter to the job, using a script. Or use execute command activity to pass as parameter and LoopActivity to loop through each Filename. ...
Can you give me the process how to send a folder as a parameter in a script ( i have to use a bat script )
can i have code for that ?