DSXchange

Hi,

Iam trying to copy latest file in a directory to the other using the below command .My DirPath1 may also contain subdirectory, so i used grep .

cp `ls -ltr #$DirPath1 | grep ^- | tail -1 | awk '{print $9}'` #$dirPath2#/.

This command works fine in putty but donot in datstage.

In the log i could see the below error message
Output from command ====>
cp: omitting directory `DirPath1'
cp: cannot stat `xyz.CSV': No such file or directory.

So ,can anyone help me out how to use this in execute comman stage.

You may need to "escape" the single-quote characters.

cp `ls -ltr #$DirPath1 | grep ^- | tail -1 | awk '{print $9}'` #$dirPath2#/

$DirPath1 is missing the right # symbol.

Put the cp into the Command field and everything else into the Parameters field. Job parameters can not be resolved in the Command field.