For Each loop

[sparkbyte]

When using a ForEachLoop to process all files in a directory how can you see what file is currently being processed?

Thanks

John Fuhrman
faq329-6766
thread329-1334328
thread329-1424438

 

[MDXer]

you can build an audit table that that you could insert file in prior to the main process in the loop. You could add a status that would be In Process then update this record with a status complete prior to the end of the loop.