SFTP Datastage 9.1 server job failing

hari.hanu · Post by **hari.hanu** » Wed Sep 11, 2013 6:35 am

Hi,

I am doing SFTP to transfer the files from my datastage server to the remote server. Inital SFTP set up is done and the user name 'A'(lets say) has been configured and tested it from command prompt.
From command prompt I am able to transfer the files to remote successfully with no issues. But when I am trying to execute the SFTP script from datastage 9.1 server job logging with user 'A' , thorwing me an error

" Command Failed to execute -Connecting to <remote server name> Could not create directory '/C=/Windows/system32/config/systemprofile/.ssh'.
Then couldn't initialise connection to server

Could any one please help me on this.

Thanks
Hanumanth

roy · Post by **roy** » Wed Sep 11, 2013 7:11 am

Hi,
Did you run the sftp from command line on the DS server machine?

hari.hanu · Post by **hari.hanu** » Thu Sep 12, 2013 3:00 am

Yes Ron. I did and transferred some files to the remote location.

Script: SFTP user@remote host server name
cd temp ----- location of the remote host server name
lcd E:/apps ---- my TEST1.txt, TEST2.txt files are here
mput TE*
bye

Thanks
Hanumanth

hari.hanu · Post by **hari.hanu** » Thu Sep 12, 2013 5:15 am

Got the result.

Added variable in the script
Set userprofile = C:\users\A
at the top of the script. It worked

Thanks
Hanumanth