topic Re: [resolved] Execute windows command using tSystem component in Talend Studio

[resolved] Execute windows command using tSystem component

Anonymous — Thu, 18 Sep 2014 04:33:59 GMT

I am trying to execute a db backup command through tSystem component. I need to pass multiple options to the command as below:
"pg_dump -h 100.1.1.2 -p 5432 -U tstusr -w -Fc -b -v -n xxx -f C:\db_bkp\xxx.bkp tstdb"
Some of the above values are passed through context variables. Hence, in tSystem component I have selected option 'Use Array Command' and provided the values as in below image

However, I get an error message stating: "Error in the component's properties:Invalid escape sequence (valid ones are \b \t \n \f \r \" \' \\ )"
Could some one point out where I am going wrong?
Thanks in advance.

Re: [resolved] Execute windows command using tSystem component

Anonymous — Thu, 18 Sep 2014 08:38:53 GMT

hi,
this is a comman 'error' : use '/' in place of '\'. it should works
regards
laurent

Re: [resolved] Execute windows command using tSystem component

Anonymous — Thu, 18 Sep 2014 08:56:22 GMT

Hi,
You need to use the escape char \ for your directory.
Best regards
Sabrina

Re: [resolved] Execute windows command using tSystem component

Anonymous — Thu, 18 Sep 2014 17:20:39 GMT

Thank you all. Its resolved