I need to connect to remote server using Sftp and rename a file. I used below command in executive command activity stage. but not working. If I execute below commands separately in putty its working fine. Any thoughts on why it is not working ? or is there any other way of doing ?
I can only do sftp to remote server not ssh or anything like that.
What's the error message? Couldn't connect to remote server? Or couldn't rename the file? What you mean by not ssh; Putty is using the SSH Proctol on port 22. Try to use sftp stage.
Under what user name does the DataStage job run (that is, how are your Engine credentials set)? Does THIS user have execute permission to the rename script?
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.