ETL and Data Integration tools - Modern ETL software for everyone

Dear Sirs,

I am currently trying to automate execution of ETL jobs: on my server, I have a bat file that will detect when a new file is added in a folder and execute the related ETL process,
Then after the executing ETL process, it will move the source file into the backup folder.
However if the ETL process "crashes", the file would be moved anyways and the user will have to restore the file before executing it again.

Is there a solution to get the status of the ETL execution that I could use as a condition of moving the file?

Thanks in advance!

You can try something like this

AdvancedETL.exe script.ats
if not errorlevel 0 echo failed

Peter

I have tried that and it did not work
Plus there is nothing about it in the documentation

Albert

You are right

Looking t it now

Peter