use tFileArchive file your job design should be like this tFileList--tFileArchive pass file name from tFileList to tFileArchive from goloble variable, and please refer Talend User guide for more information.
hi, thanks .. But problem is when i upload this gzip file into redshift we are not able to load into the amazon redshift database. so i am thinking there might be the problem with gzip which is not supporting equvalent to redshift
Hi, I have never load .gzip file into DB. Perhaps you should take a consideration on field type or something else on DB. If the .gzip files are correct, I think the tFileArchive is alright. Best regards Sabrina
-- Don't forget to give kudos when a reply is helpful and click Accept the solution when you think you're good with it.
I am actually trying to do the same exact thing. Load a gzip file into s3 and then use RedShifts copy command along with its gzip feature to push the data into RedShift. I have used tFileArchive to gzip the file and result in the following error: Error : ERROR: Failed writing body (0 != 8645) Cause: Failed to inflateinvalid or incomplete deflate data. zlib error code: -3 I run into no issues when I use the command "gzip -c file.txt > file.gz" to gzip the file.