ETL and Data Integration tools - Modern ETL software for everyone

hello all:
I am having an issue either moving, copying or merging files from a source directory to a destination directory after processing.
The problem occurs when I have more then one file in the source directory matching a wild card mask of the source file. for example as follow:

source: c:\ftp\guest*.csv
destination: c:\ftp\old\guest*.bak

my goal is to simply copy the file to a new location and change the file extension.

any help would be appreciated.

thanks

mike

Mike

We would need to modify our software to do it.
Hope it will be ready for you next week.

I personally never understood why people want to rename files after loading.
You may need to rename them back later
Plus They take space

I prefer to create zip files something like dayload_yyyymmddhhmmss.zip
Or just create a folder for every load and move files there

Peter

Hello

Can you give version 4.2.3.0 a try please

Changes are:

Support for SFTP was introduced
Export of empty tables was fixed
Various problems related to working with very large files were resolved
Copy and Move file operations can also rename multiple files
Put into target directory:
{ChangeFileExt('<File Operation Source File>','.old')}
C:\{ExtractFileName(ChangeFileExt('<File Operation Source File>','.old'))}
Calculation was not showing result correctly in preview mode

To rename multiple files you need to put calculation in the target directory

{ChangeFileExt('<File Operation Source File>','.old')} to rename files in same directory
C:\{ExtractFileName(ChangeFileExt('<File Operation Source File>','.old'))} to copy/move files into different directory

Please let us know outcome,
Peter