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

Highlighted
Nine Stars

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

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.

Tags (2)

Accepted Solutions
Fifteen Stars TRF
Fifteen Stars

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

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

Capture.PNG

 

 


TRF

All Replies
Fifteen Stars TRF
Fifteen Stars

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

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:Capture.PNG

Enjoy!

 


TRF
Nine Stars

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

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.

 

 

Fifteen Stars TRF
Fifteen Stars

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

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
Fifteen Stars TRF
Fifteen Stars

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

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

Capture.PNG

 

 


TRF

What’s New for Talend Spring ’19

Watch the recorded webinar!

Watch Now

Definitive Guide to Data Quality

Create systems and workflow to manage clean data ingestion and data transformation.

Download

Tutorial

Introduction to Talend Open Studio for Data Integration.

Watch

Downloads and Trials

Test drive Talend's enterprise products.

Downloads