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
