ETL and Data Integration tools - Modern ETL software for everyone

Hi there

We are using the Advanced ETL Processor Enterprise edition to run a daily extract from a MS SQL database that extracts change data from 25 tables with a CSV file generated for each table. The last processing step in the package is to Zip up all the CSV files into a single Zip file.

All of this is working, however at the beginning of each file that is compressed is the word “Error”.

Would like to know if there is some error that is causing the message, also when the logs are examined each day, the client is then spending time checking whether there is a problem that has effected the run.

Looking back through the logs this has been happening for some weeks

Following is a screen shot of the log listing and the package object that is the compression run – Repository attached.

<FFA Extract files>{SubString(GETSYSTEMVARIABLE('SYSTEM_DATE'),7,2)}\<Country Code>_*.csv

The above is the full compress line output file statement

Regards,
Andrew

Looking at it now

Peter

Was fixed in latest version

4.2.6.13

Format field names dialogue box was introduced
Added quote all menu item
Fixed problem with compressing files
Various bug fixes