topic Re: How do I get the output from a .bat using tSystem? in Talend Studio

How do I get the output from a .bat using tSystem?

talendtester — Thu, 27 Apr 2017 21:45:36 GMT

I have a simple .bat job which prints the date time

@echo off echo %date:~10,4%-%date:~4,2%-%date:~7,2% %time:~0,2%:%time:~3,2%:%time:~6,2% exit;

I call the .bat job with tSystem component:

command "cmd /c start D:\\myDate.bat"

How do I write the returned date time to a file?

I tried all the Standard Output choices but every time a blank line is written to my output file.

TRF — Thu, 27 Apr 2017 22:20:46 GMT

In tSystem set "Standard Output" to "to Global variable".

Now the result is available from tSystem_2_OUTPUT (in tSystem name is tSystem_2).

You can easily put the result into a file using a tFixedInputFlow connected to a tFileOutputDelimited (for example).

Here is the tFixedInputFlow:

Enjoy!

talendtester — Thu, 27 Apr 2017 23:48:28 GMT

Starting a .bat in the Command of tSystem I wasn't able to get it to pass back the output of the .bat.

My job looks like: tSystem_1 onSubjobOk tFixedFlowInput_1>tFileOutputDelimited_1.

Apparently the echo date time command must be in the Command of tSystem.

TRF — Fri, 28 Apr 2017 07:00:09 GMT

Not necessary. In the example I give, I used a command file, just removed the exit, the rest is copy/paste from your script.

TRF — Fri, 28 Apr 2017 08:49:44 GMT

Just to be sure, here is a capture of my tSystem component: