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