ETL and Data Integration tools - Modern ETL software for everyone

I downloaded Advanced ETL Processor Pro version 4.2.4.3 yesterday and I am now having a problem with archiving client files via the File Operator - Move File. I am creating a directory then moving files to the newly created directory utilizing the GetSystemDate functionality.


I am creating a directory in the following manner:
G:\???\???\ETL\Load Files\???\Archived Files\{GetSystemDate('YYYYMMDD')}

I am then moving files in the following manner:

Source File:
"G:\???\???\ETL\Load Files\???\Files To Load\*.csv"

Target Directory:
G:\???\???\ETL\Load Files\???\Archived Files\{GetSystemDate('YYYYMMDD')}

This was a successfull approach in a previous version of the tool. Am I doing something wrong?

Thanks for your support.

This might happen if you run it several times
For example while testing.
It is failing because there are already some files in target directory
Try selecting overwrite existing files.

We will make error messages more informative in the next release

Peter

Hi Peter,

There definitely are no files in the target directory.

The strange thing is it works fine if the target directory is an actual file name and not the {GetSystemDate('YYYYMMDD')}. See below.

It works if the target directory is:
G:\itg\Business Intelligence\ETL\Load Files\ClientName\Archived Files_ClientName\20110221

It does NOT work if the target directory is:
G:\itg\Business Intelligence\ETL\Load Files\ClientName\Archived Files_ClientName\{GetSystemDate('YYYYMMDD')}

Also, it worked fine in a previous version of your tool.

Still thinking what can be wrong with that

The question marks?
What are they?

Have you got any unicode characters in the directory name?

G:\???\???\ETL\Load Files\???\Archived Files\{GetSystemDate('YYYYMMDD')}

Peter

Hi Peter,

I simply replaced the client name with question marks for this posting only.

No unicode characters in directory name. The target directory would look very similar to the following:

G:\itg\Business Intelligence\ETL\Load Files\ClientName\Archived Files_ClientName\{GetSystemDate('YYYYMMDD')}

Thanks

Steve

Can you try version Advanced ETL Processor Professional version 4.2.4.4 please
If it does not work please post here your execution log

Peter