ETL and Data Integration tools - Modern ETL software for everyone

Hi

I have Advanced ETL Pro, v3.2.0.8.


I am sent a file every week whose name changes. The root of it is the same each time, but the file name contains a date.

Is there any way I can rename a file using a mask? For example root*.xls to root.xls.


I am downloading the file from an FTP, so don’t know if the FTP rename is capable of doing this? The file operation rename doesn’t seem to work like this.


Kind regards, Andrew

Two ways of doing it

You may just use a Merge file operation action

Information 08/04/2009 19:13:38 Preparing to execute Weekly Repository Backup
Information 08/04/2009 19:13:38 Package Started
Information 08/04/2009 19:13:38 Executing File Operation: Unknown
Information 08/04/2009 19:13:38 Source File(s): C:\\TEMP\\1\\sript*.vis
Information 08/04/2009 19:13:38 About to be merged into: C:\\TEMP\2\sript.vis
Information 08/04/2009 19:13:38 Found: 1 File(s) to Merge
Information 08/04/2009 19:13:38 Path: C:\\TEMP\\1\\
Information 08/04/2009 19:13:38 Mask: sript*.vis
Information 08/04/2009 19:13:38 File is Merged: C:\\TEMP\\1\\sript20090408.vis
Information 08/04/2009 19:13:38 Package Finished

You need to make sure that your file is the only one in source directory (taking into account the mask)

You may use Rename file operation action

use C:\\TEMP\\1\\sript{GetSystemDate('YYYYMMDD')}.vis as a source file

only one pair {} is allowed
full list of functions is in documentation

during execution C:\TEMP\1\sript{GetSystemDate('YYYYMMDD')}.vis will be converted into
C:\TEMP\1\sript20090408.vis

Information 08/04/2009 19:23:06 Preparing to execute Weekly Repository Backup
Information 08/04/2009 19:23:06 Package Started
Information 08/04/2009 19:23:06 Executing File Operation: Unknown
Information 08/04/2009 19:23:42 File renamed: C:\\TEMP\\1\\sript20090408.vis
Information 08/04/2009 19:23:42 To: C:\\TEMP\\2\\sript.vis
Information 08/04/2009 19:23:42 Package Finished

please try new Unicode version of Advanced ETL Processor
it is up to 30 percent faster

Enterprise 3.3.0.0

www.dbsoftlab.com/tmp/AdvancedETLEnt.zip

Professional 3.3.0.0

www.dbsoftlab.com/tmp/AdvancedETLPro.zip

Standard 2.4.0.0

www.dbsoftlab.com/tmp/AdvancedETL.zip


Best regards,
Peter

Excellent – thanks very much.

Kind regards, Andrew