This simple ETL job executes a batch file. It is recommended to use absolute paths in ETL scripts and in batch scripts.

Used drivers:

  • Groovy
<!DOCTYPE etl SYSTEM "https://scriptella.org/dtd/etl.dtd">
<etl>
<description>Executing Windows Batch File</description>
<connection id="groovy" driver="script">language=groovy</connection>
<script connection-id="groovy">
println "cmd /c C:\\path\\batch1.bat".execute().text
</script>
 
</etl>

Example of batch file (e.g. batch1.bat)

@ECHO OFF
 
type nul >C:\path\EmptyFile.txt