someone knows how can I list the name of files in some file directory that had my File Datasouce configurated ?
I need include in my ODI package a steps that returns a list of exists files in the directotry
Ex.: I had a data server "FILE_CCRS./arquivos_odi/ccrs/in" which directory is "/arquivos_odi/ccrs/in" and a need to
get the list of names of files belong of this directory, some like the result od the DIR comand( see below ):
I need to create something like a refress variable with this values( name of afiles ) above
Use OdiOscCommand or else create script file with below codes
ls /home/your_user_name_or_any_source_path/*.txt > /home/your_user_name_or_any_destination_path/filenames.txt
Above code will create file filename.txt which keeps the list of filename ( only text file due to mask).
Now you need to read filename one by one from filename.txt and use this in your variable.
For windows you can get the command from below link and the logic to process all file in next link.