How to send pushd / popd command using tsystem component ?

One Star

How to send pushd / popd command using tsystem component ?

I am trying to send array of system commands thru tSystem component.
command strings are,
"cmd /c pushd \\\\10.0.100.58\\ConsoleLive\\BI Integration Data\\Backup\\RetailerTextData "
"cmd /c move *.csv importedforgisserver"
"cmd /c popd"

I am getting error as given below.
-------
Exception in component tSystem_1
java.io.IOException: Cannot run program "cmd /c pushd \\10.0.100.58\ConsoleLive\BI Integration Data\Backup\RetailerTextData": CreateProcess error=2, The system cannot find the file specified
-------
Pl. advice.

One Star

Re: How to send pushd / popd command using tsystem component ?

There s nothing specific to tSystem component here. Try these things:
- Running this command through command prompt.
- Running single command at a time
This will help you to pin point the error area.
One Star

Re: How to send pushd / popd command using tsystem component ?

sankalp.verma wrote:
There s nothing specific to tSystem component here. Try these things:
- Running this command through command prompt.
- Running single command at a time
This will help you to pin point the error area.

Thanks for the input ,
I already tried ,there was no success in that so i have posted it here.

I guess talend can't handle //// continuous characters or i am doing something wrong in sending command.


(ROOT CAUSE : to use UNC path is when talend jobs with mapped network drive is executed manually it runs fine but the same will fail when scheduler tries to run it( windows 2008 R2). So i have to get help of UNC path and pushd popd here.)

Waiting for a reply from talend they are working on the issue.

Thanks.
One Star

Re: How to send pushd / popd command using tsystem component ?

In the past I have been able to use "\\\\" UNC paths to execute command using tSystem component. Can you try executing one command at a time?
One Star

Re: How to send pushd / popd command using tsystem component ?

sankalp.verma wrote:
In the past I have been able to use "\\\\" UNC paths to execute command using tSystem component. Can you try executing one command at a time?

Yes, it is not giving me errors if i use it as single commands. Thanks.
One Star

Re: How to send pushd / popd command using tsystem component ?

Then my idea will be to separate multiple commands with ";" and try to put multiple commands in a batch or script file and call that script file from talend. 

2019 GARNER MAGIC QUADRANT FOR DATA INTEGRATION TOOL

Talend named a Leader.

Get your copy

OPEN STUDIO FOR DATA INTEGRATION

Kickstart your first data integration and ETL projects.

Download now

What’s New for Talend Summer ’19

Watch the recorded webinar!

Watch Now

Best Practices for Using Context Variables with Talend – Part 4

Pick up some tips and tricks with Context Variables

Blog

How Media Organizations Achieved Success with Data Integration

Learn how media organizations have achieved success with Data Integration

Read

Why Companies Move to the Cloud: 7 Success Stories

Learn how and why companies are moving to the Cloud

Read Now